MySQL 5 + MX7 stored proc problem

[jperkins99]

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?

[jperkins99]

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.