I'm at a loss to explain this. When I create a recordset with Dreaweaver and test, three fields are blank. I have run the same query in phpMyAdmin and it worked fine. I also recreated the database in Access and the query ran fine. Here are the two tables and fields:

[tblArticles]
idArticles
fldDate
fldTitle
fldDescription
fldShortDesc
fldVisible
idCategories

[tblCategories]
idCategories
fldTitle
fldDescription

The query in question is:
SELECT *
FROM tblarticles LEFT JOIN tblcategories ON tblarticles.idcategories = tblcategories.idcategories

As I said earlier, in phpmyadmin and access they run fine. In Dreamweaver 8 the last three fields are always blank. Anyone have any ideas? I have also run variations on this query with the same results.

Edited by - rekem on 05 Feb 2006 02:53:17

this happens to me too sometimes but i found that if you save anyway and test in a browser it sometimes works despite dreamweavers inability