Dreamweaver/MySQL/MyODBC sql LIMIT error
Posted on 2003-03-19
This is killing me, and I imagine it is something simple.
I am working with Dreamweaver, a hosted MySql db, and connecting through MyODBC on my local machine. With the MySQL Control Center 0.8.10-beta, I have no issue testing the following sql statement, and it returns exactly as it should.
order by bill_id desc
Simple enough, right?
Well, when I am creating a recordset in Dreamweaver, use the Advanced option, and enter in the exact same SQL, it just doesn't seem to want to go through. Does this error message mean anything to anyone?
"[TCX][MyODBC] You have an error in your SQL syntax near 'limit 100' line 4"
Since it works with the MySQL interface, I would point to Dreamweaver/MyODBC, but this seems like a pretty simple query that wouldn't cause a problem. Any option I didn't check eith MyODBC or dreamweaver quirk?
I can actually just force the sql into the recordset anyway, upload the files to the host, and it will work on the site, but it does bother me about not working locally.
Any help would be apprecaited... Thanks.