?
Solved

MYSQL - Error Message in Dreamwaver 8.02

Posted on 2006-06-07
7
Medium Priority
?
194 Views
Last Modified: 2010-08-05
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?

0
Comment
Question by:cescentman
6 Comments
 
LVL 3

Expert Comment

by:Onyx23
ID: 16862425
Post your the entire existing DW SQL statement :>)
0
 
LVL 11

Expert Comment

by:dodge20
ID: 16862505
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
 
LVL 1

Author Comment

by:cescentman
ID: 16865242
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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 1

Author Comment

by:cescentman
ID: 17050535
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
 
LVL 1

Author Comment

by:cescentman
ID: 17050593
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
 

Accepted Solution

by:
CetusMOD earned 0 total points
ID: 17269551
PAQed with points refunded (500)

CetusMOD
Community Support Moderator
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed.   I'm not sure why Microsoft tends to release OS' that should not be released but they do.  Windows…
Screencast - Getting to Know the Pipeline
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question