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:240546
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
