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.