Dreamweaver Mx/SQL Error : Command text was not set for command object
Hya all,
Im developing a website in dreamweaver mx with database facilities
I have created a recordset, and on the sql query i have put
::::
Select Count(Phone) as TotalCount
from Phone
Group by Phone
::::
When i click the test button, it display correctly the desired results, but when i click OK and the recordset is made, i m not able to drag and drop the results on the page...
It keeps giving me the error message >> Command text was not set for command object
-------
you must give us more information, Have you look on macromedia.com for update on the version you use. some times with dreameweaver you have to go under the hood to see what's going on. I get so mutch problemes using dreamweaver's querry. If i could give you my opinion write your own querry. the one your write is simple.
Dreamweaver Mx/SQL Error : Command text was not set for command object
Linear Mode
