Which JDBC driver are you running? If you're running the default CF7 install then you're only working with a 3.51 driver. There are Adobe Technotes on how to upgrade and specify (but you will require server access).
Cutter Joelle Tegwen wrote: > I'm running CFMX 7 with MySQL 5.0 on Windows > > I've got this query: > <cfquery name="findAssignments" datasource="[dsn]" debug="true"> > SELECT * > FROM assignment > WHERE projectID=#arguments.project.getProjectID()# > <!--- WHERE projectID=<cfqueryparam > value="#Arguments.project.getProjectID()#" cfsqltype="cf_sql_tinyint"> ---> > ORDER BY x500, startDate DESC > </cfquery> > > the dsn has full CRUD privileges on this table > > When I run the statement in the Query Browser I get my expected results. > When I run them in CF I get this: > > Error Executing Database Query. > [Macromedia][SequeLink JDBC Driver]An internal error occurred. > > The error occurred in > C:\Projects\timeTracking\components\AssignmentHome.cfc: line 55 > Called from [snip] > > 53 : SELECT * > 54 : FROM assignment > 55 : WHERE projectID=#arguments.project.getProjectID()# > 56 : <!--- WHERE projectID=<cfqueryparam > value="#Arguments.project.getProjectID()#" cfsqltype="cf_sql_tinyint"> ---> > 57 : ORDER BY x500, startDate DESC > > SQL SELECT * FROM assignment WHERE projectID= 43 ORDER BY x500, > startDate DESC > DATASOURCE trackingMgr > VENDORERRORCODE 7369 > SQLSTATE HY000 > > The odd thing is that 7369 isn't a valid error code for MySQL. > > How do I begin figuring out what is going on here? > > Thanks > Joelle > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240567 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
