unidentified error has occurred

[Charles67]

While attempting to create a recordset in DW when I click on 'test' I get "An unidentified error has occurred. Does anyone know of a fix for this? Any help will be greatly appreciated.

[Charles67]

I should add that I am using DW8 on Windows XP Pro. I get the error message while trying to create an inner join using php 5 and MySQL5. The code is from Dreamweaver 8 with ASP, Coldfusion and PHP training from the source. Here is the code:
SELECT * FROM tbl_tours INNER JOIN tbl_country
ON tbl_country.countryID=tbl.tours.country
ORDER BY tbl_country.countryName

I really need help with this.

[Newsgroup_User]

You state that your table is called tbl_tours but in your ON clause you
reference it as tbl.tours.country.

If this is how your SQL query really is formed then that would certainly
throw an error.

Pat.


"Charles67" <webforumsuser@macromedia.com> wrote in message
news:f38hqn$8ap$1@forums.macromedia.com...
>I should add that I am using DW8 on Windows XP Pro. I get the error
>message
> while trying to create an inner join using php 5 and MySQL5. The code is
> from
> Dreamweaver 8 with ASP, Coldfusion and PHP training from the source. Here
> is
> the code:
> SELECT * FROM tbl_tours INNER JOIN tbl_country
> ON tbl_country.countryID=tbl.tours.country
> ORDER BY tbl_country.countryName
>
> I really need help with this.
>

[Charles67]

Yes, I fixed this error which did not fix my problem. Once I narrowed down the error to one table, I found a corrupt column. When I dropped that column the problem was solved. Thanks for your input.