FWIW: I'm using the 3.0.17-ga driver also. Haven't had any problems. On 5/15/06, Denny Valliant <[EMAIL PROTECTED]> wrote: > > You'll probably want to run the 3.0.17-ga driver if you're using 5. > > I didn't have any troubles with 3.1.7 and MySQL 4.1, but it was > slow as molasses with MySQL 5. Downgrading seems to have sped > things up considerably. Newer driver versions (than 3.1.7) seem to > have the same problem. > > :De > > On 5/15/06, Cutter (CFRelated) <[EMAIL PROTECTED]> wrote: > > > > 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:240608 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
