title: cfstoredproc no longer returns results after CF11 update 5
body: <p>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:</p>
  
  <pre><code>&lt;cfstoredproc procedure="proc_xxxx" datasource="#application.dsn#" debug="yes" returnCode="yes"&gt;
  &lt;cfprocparam type="in" cfsqltype="cf_sql_integer"  dbvarname="@myID" value="#arguments.myID#"&gt;
  &lt;cfprocparam type="in" cfsqltype="cf_sql_varchar"  dbvarname="@EmailAddr" value="#trim(arguments.emailAddress)#"  null="#not len(arguments.emailAddress)#"&gt;
  &lt;cfprocparam type="out" cfsqltype="cf_sql_integer" dbVarName="@NewUserID"  variable="newUserID" &gt; 
  &lt;cfprocresult name="qryUser"&gt;   
  &lt;/cfstoredproc&gt;
  
  &lt;cfoutput&gt;newUserID = #newUserID#&lt;/cfoutput&gt;
  </code></pre>
  
  <p>I get a newUserID not defined error. Again, everything used to run fine prior to update 5.</p>
  
  <p>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.</p>
  
  <p>I tried :</p>
  
  <pre><code> &lt;cfprocresult resultset="1" name="qryResult"&gt;
  </code></pre>
  
  <p>With no luck. Any ideas? Thanks in advance.</p>