MX vs v5 Stored Procedure Problem

[davidwendelken]

I have to upgrade a CF v5 application I inherited to CF MX.

I know that there is a problem with porting the code using stored procedures to MX. I found this comment in the existing code from my predecessor.

I don't have an MX version set up to test with yet, but I'm trying to get a leg up on it. Can't give the error message that goes with this until the MX system is set up again, but I do know it won't compile. I confirmed that some months ago, but wasn't in a position to pursue it then.

Any guidance on what I have to do differently?

<cfstoredproc
procedure="pkg_x.getStuff"
datasource="#mysession.dcname#"
blockfactor=20
>
<cfprocparam
type="In"
maxlength="10"
cfsqltype="CF_SQL_INTEGER"
value="#session.currentorg#"
>
<!--- this CF_SQL_REFCURSOR only works for cf5
and causes errors in MX
--->
<cfif left(mysession.cfProductVersion,1) LT "6">
<!--- had to pull this out of because
it doesn't compile on CF/MX
--->
<cfprocparam
type="Out"
cfsqltype="CF_SQL_REFCURSOR"
variable="Yo2"
maxrows="-1"
>
</cfif>
<cfprocresult name="the_answers">
</cfstoredproc>


David Wendelken

http://www.casetech.net