Nevermind...the problem was that I needed to "SELECT" the variables at the end of the stored proc in order to return the values to coldfusion.
I had the usual issues with driver incompatibility: "null null" error and then, after installing connector/j 3.0.17 I got "Callable statments not supported". I could not find the elusive 3.2 driver on the mysql site, so we installed the 5.0 driver (beta). Now, I'm not getting any results returned from my stored proc. The error is: -- Element RECORDCOUNT is undefined in QSIMPLEPROC I also tried pulling the statuscode and got: -- Element STATUSCODE is undefined in CFSTOREDPROC The debugging looks correct. it appears that the stored proc is running (liberties taken with formatting to make it readable): simpleproc (Datasource=test, ...
I had the usual issues with driver incompatibility: "null null" error and then,
after installing connector/j 3.0.17 I got "Callable statments not supported".
I could not find the elusive 3.2 driver on the mysql site, so we installed the
5.0 driver (beta).
Now, I'm not getting any results returned from my stored proc. The error is:
-- Element RECORDCOUNT is undefined in QSIMPLEPROC
I also tried pulling the statuscode and got:
-- Element STATUSCODE is undefined in CFSTOREDPROC
The debugging looks correct. it appears that the stored proc is running
(liberties taken with formatting to make it readable):
simpleproc (Datasource=test, Time=0ms) in //_qry_financialAggregate.cfm
10:36:38.038
parameters
----------------
type = OUT
CFSQLType = cf_sql_integer
value =
variable = oID = oID
dbVarName
resultsets
----------------
name = qSimpleproc
resultset = 1
But...nothing is returned. What gives?
Nevermind...the problem was that I needed to "SELECT" the variables at the end of the stored proc in order to return the values to coldfusion.
Bookmarks