I have several SQL Server 2008 stored procedures. I am calling them via cfstoredproc. After I run a CF server update on April 17th, CF does not get the results anymore. Here is one of the calls:
<cfstoredproc procedure="proc_xxxx" datasource="#application.dsn#" debug="yes" returnCode="yes">
<cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="@myID" value="#arguments.myID#">
<cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="@EmailAddr" value="#trim(arguments.emailAddress)#" null="#not len(arguments.emailAddress)#">
<cfprocparam type="out" cfsqltype="cf_sql_integer" dbVarName="@NewUserID" variable="newUserID" >
<cfprocresult name="qryUser">
</cfstoredproc>
<cfoutput>newUserID = #newUserID#</cfoutput>
I get a newUserID not defined error. Again, everything used to run fine prior to update 5.
If I call the stored procs in SSMS, everything works fine. The cfstoredproc works as I am seeing my updates and inserts on the database. However, it simply won't return any results back anymore. Return code is 0, as I mentioned everything runs without any errors.
I tried :
<cfprocresult resultset="1" name="qryResult">
With no luck. Any ideas? Thanks in advance.
After quite a few back and forth emails with Adobe support, they told me to uncheck : Enable Request Debugging Output in CF admin.
Once done, the parameter comes back as expected:
<cfprocparam type="out" cfsqltype="cf_sql_integer" dbvarname="@NewUserID" variable="newUserID" >
Needless to say, we need the debug outputs on local and development servers. I don't believe this bug should be marked as fixed but I guess they are doing so.
Hope it helps someone else who runs into same issue.
EDIT on 1 May 2015 : There is a fix for this now.
Boom, it works!
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With