have you tried retying the query? cause that is not an astrix in that error message
looks like its been copyied and pasted from some microsoft application or something Steve -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Seona Bellamy Sent: Tuesday, June 29, 2004 10:17 AM To: CFAussie Mailing List Subject: [cfaussie] Slightly OT perhaps - MySQL doesn't want to play. Hi guys, I have a problem here. I had a CF application that was working fine when it was talking to an Access database. Then I moved across to a new server with a MySQL database. Now my query doesn't work. :( The query is: <cfquery name="qry_GetAllCategories" datasource="#session.dsn#" username="bleep" password="bleep"> SELECT * FROM Category </cfquery> The error I'm getting is: Error Occurred While Processing Request Error Diagnostic Information 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 '�' at line 1 The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:106). The error occurred while processing an element with a general identifier of (CFRETHROW), occupying document position (246:11) to (246:21). Date/Time: 06/28/04 17:11:12 Browser: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6) Gecko/20040113 Remote Address: 203.173.164.200 HTTP Referrer: http://216.119.123.23/index.cfm?fuseaction=admin.Hub Query String: fuseaction=admin.manageCategories I've looked through online manuals and even tried logging in to the server's control panel where there is a section that allows you to test queries to the database - funnily enough, when I just enter the SQL code, it works fine. So I'm guessing it's a problem with the <cfquery> statement. What do I need to change to make it work right? Any suggestions would be greatly appreciated. Cheers, Seona. __________________________________________________________________ << ella for Spam Control >> has removed Spam messages and set aside Later for me You can use it too - and it's FREE! http://www.ellaforspam.com --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.710 / Virus Database: 466 - Release Date: 23/06/2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
