MYSQL - Error Message in Dreamwaver 8.02

I have set up a connection item to a MySQL connection on a windows hosted site:-

"DRIVER={MySQL ODBC 3.51
Driver};SERVER=somehost.co.uk;DATABASE=DBName;PORT=3306;UID=Username;PAS
SWORD=password;OPTION=3;"

When I click test on the Custom Connection String window I get the
message:-

"Connection was made successfully." and the tables and their properties show in the databases window. However when I click

However when I select View Data by right clicking on one of the tables I get the message:-

"[MySQL][mysqld-4.0.24_Debian-10ubuntu2.1-log]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DBName.Groups limit 100' at line 1."

A similar error prevents me from setting any dynamic list boxes etc. If I create a PHP page to access the same database then it works fine and DW does not return any errors. Also I have tried to run the MySQL connection by checking "Using driver on this machine" on the Custom Connection String window. Again it shows the tables and properties and returns the error when trying to view data. However this only proves that the problem is in Dreamweaver It doesn't help me get the windows site developed.

I am advised by Shawn K. Hall on the yahoo Macromedia Dreamweaver site that the issue is that the Limit clause has two arguments, and while one is supposedly optional, I believe the 4.0.x builds had it required. The first parameter is the offset, the second is the rowcount. This portion of the SQL should then be "DBName.Groups limit 0, 100".

What I don't know is how to amend the SQL string that DW is using. Does anyone have any suggestions how I resolve this?

LVL 1
cescentmanAsked:
Who is Participating?
 
CetusMODCommented:
PAQed with points refunded (500)

CetusMOD
Community Support Moderator
0
 
Curtis ShullFounderCommented:
Post your the entire existing DW SQL statement :>)
0
 
dodge20Commented:
I have run into this before also.  I had tried about every syntax option I could think of, but nothing worked.  So just for fun, I uploaded the page and it worked fine.  For some reason dreamweaver doesn't like Limit syntax while testing the queries.  Have  you tried actually testing your page?
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
cescentmanAuthor Commented:
You miss the point, I can't get as far as creating an SQL statement, as soon as I try to create a record set I get this error. It's obviously an SQL request that DW is firing off in the baclground in order to feed the server behaviour interface.
0
 
cescentmanAuthor Commented:
I have now sorted this - no thanks to Macromedia Support who refused point blank saying that ASP and MySQL were not supported. I wonder sometimes why I spend so much money with them.  

The issue was simply that the Database name contained a "-" I removed this and bingo.
0
 
cescentmanAuthor Commented:
I reqeust a refund as I have now resolved this myself, I think however it could stay as the problem may be faced by other users.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.