Well, it seems to have been a stab in the right direction. I tried a couple more things and eventually discovered that it didn't like me giving it the username and password as attributes of <cfquery>, but wanted them included as connectstring="uid=bleep;password=bleep". *sigh* Fun, eh? Any ideas why it cares?
Thanks for the suggestions. Cheers, Seona. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark M Sent: Tuesday, 29 June 2004 10:29 AM To: CFAussie Mailing List Subject: [cfaussie] Re: Slightly OT perhaps - MySQL doesn't want to play. 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/ --- Incoming 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 __________________________________________________________________ << 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
<<attachment: winmail.dat>>
--- 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/
