It's not the query. It's ALL queries. :)
>?
>
>-----Original Message-----
>From: Bud [mailto:[EMAIL PROTECTED]
>Sent: Friday, February 20, 2004 13:50
>To: CF-Talk
>Subject: MySQL and CF 5
>
>Hi. I just got this response to a support request from Crystal Tech.
>
>"CF 5 does not support DSNs using MySQL. You have to specify a
>connection string."
>
>Obviously this isn't true. I can connect to their MySQL Server from
>here at home using the same driver (3.51). I tried to explain that
>the only thing CF 5 can't do is MANAGE the DSNs through the CF Admin.
>No response yet.
>
>Here is the error I get whenever trying to run a cfquery. Any clues
>on what the problem may be? I've tried from 2 separate servers, but
>both databases are on mysql5.
>
>By the way, the ONLY difference in the error from one servers to
>another is the '2' (in near '2') is '1' on one of the servers.
>
>ODBC Error Code = 37000 (Syntax error or access violation)
>
>[MySQL][ODBC 3.51 Driver]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 '2' at line 1
>
>The error occurred while processing an element with a general
>identifier of (CFQUERY), occupying document position (4:1) to (4:72).
>
>Thanks!
>--
>
>Bud Schneehagen - Tropical Web Creations, Inc.
>
>_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
>Web Based Solutions / eCommerce Development & Hosting
><http://www.twcreations.com/>http://www.twcreations.com/ -
><http://www.cf-ezcart.com/>http://www.cf-ezcart.com/
>Toll Free: 877.207.6397 - Local & Int'l Phone/Fax: 386.789.0968
> _____
>
>[
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
