Just for a stab in the dark, I'm going with the 'access violation' rather than the 'syntax error'.
Make sure the user account that CF is using has the appropriate permissions to run what you are trying. Just a thought. Mark ------------------------------------------------------------------ E: [EMAIL PROTECTED] W: www.compoundtheory.com ICQ: 3094740 Quoting Seona Bellamy <[EMAIL PROTECTED]>: > 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/
