Joelle, If you subsitute in a known good ID instead of the variable values for project ID, does your cfquery work then? I'm suspecting that perhaps the getProjectID() method in the cfc may not have its "output" attribute set to false, thus possibly returning some extra space with your actual project ID.
Just something to look at. Doug :0) >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:240708 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
