1 Reply Latest reply on Dec 17, 2014 6:38 AM by haxtbh

    CF 11 Post Update 3 Issue - [SQLServer JDBC Driver][SQLServer]Procedure or function expects parameter which was not supplied.

    sdbelt1

      ColdFusion 11 Details:

       

      Server Details
      Server Product ColdFusion
      Version 11,0,03,292480 
      Tomcat Version 7.0.54.0
      Edition Developer  
      Operating System Windows 8  
      OS Version 6.2  
      Update Level C:/ColdFusion11/cfusion/lib/updates/chf11000003.jar  
      Adobe Driver Version 5.1.3 (Build 000094) 

       

      Sample error:

       

      queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Procedure or function 'ListClientDPReceiptFormat' expects parameter '@idCient', which was not supplied.
      where (param 1) = [type='IN', class='java.lang.Integer', value='4', sqltype='CF_SQL_INTEGER']

       

      Stored Procedure:

       

          <CFSTOREDPROC procedure="ListClientDPReceiptFormat">
         <CFPROCPARAM TYPE="IN" DBVARNAME="@idClient" VALUE="#Request.Client.Id#" CFSQLTYPE="CF_SQL_INTEGER">
         <CFPROCRESULT NAME="qryDPReceiptFormats">
         </CFSTOREDPROC>

       

      This stored procedure and others like it worked fine until CF 11 update 3 was applied.

       

      Thanks!