Cfstoredproc no longer returns results after updating CF11 5

Question

I have several SQL Server 2008 stored procedures. I call them through cfstoredproc. After I start updating the CF server on April 17th, CF no longer receives the results. Here is one of the challenges:

<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 error not defined. Again, everything that was used to work before update 5.

If I call the saved procs in SSMS, everything will be fine. Cfstoredproc works since I see my updates and inserts in the database. However, it will no longer return any results. The return code is 0, as I mentioned that everything works without errors.

I tried:

  <cfprocresult resultset="1" name="qryResult"> 

Bad luck. Any ideas? Thanks in advance.

Answer 1

After several emails with Adobe support, they told me to uncheck the box: Enable output debugging request in CF administration.

After the parameter is executed, it returns as expected:

  <cfprocparam type="out" cfsqltype="cf_sql_integer" dbvarname="@NewUserID" variable="newUserID" > 

Of course, we need debugging outputs on local and development servers. I do not believe that this error should be marked as fixed, but I assume that they do.

Hope this helps someone else who is facing the same problem.

EDIT May 1, 2015: There is a fix for this.

• Download this hotfix file [hf1100-3971083.jar].
• Put this file in the / cfusion / lib / updates folder.
• Restart the ColdFusion application service.

Boom, it works!