MYSQL - Error Message in Dreamwaver 8.02

Posted on 2006-06-07
Last Modified: 2010-08-05
I have set up a connection item to a MySQL connection on a windows hosted site:-


When I click test on the Custom Connection String window I get the

"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?

Question by:cescentman
    LVL 3

    Expert Comment

    Post your the entire existing DW SQL statement :>)
    LVL 11

    Expert Comment

    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?
    LVL 1

    Author Comment

    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.
    LVL 1

    Author Comment

    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.
    LVL 1

    Author Comment

    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.

    Accepted Solution

    PAQed with points refunded (500)

    Community Support Moderator

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    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…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    758 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now