3 Replies Latest reply on Dec 26, 2016 8:41 AM by BKBK

    ColdFusion 2016 and Stored Procedure -dbvarname

    weezerboy Level 1

      There was discussion that ColdFusion was going to deprecate dbvarname with cf2016

       

      I have code like this that works in CF2005 but I am migrating to CF2016 and am having issues with the Stored Procedure -dbvarname

       

      This no longer works

       

      <cfstoredproc datasource="#live#" procedure="ABX1265">

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

          <cfprocparam cfsqltype="cf_sql_char" dbvarname="@COMPANY"   type="in" value="#companyCode#" >

          <cfprocparam cfsqltype="cf_sql_char" dbvarname="@ENVIRONMENT" type="in" value="#arguments.environment#">

      </cfstoredproc>

       

        <cfquery name="out2" datasource="LIVE#companyCode#" >

      #resultXML#

      </cfquery>