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/
