Could you please tell me the update level of ColdFusion.
ColdFusion Enterprise 12.0
Patrick Hutchinson | Office: 804-370-6873
@Weezerboy, I have to assume that, by CF2005 and ColdFusion Enterprise 12.0, you mean Coldfusion 5 and ColdFusion 2016 Enterprise. Yes, dbVarname was deprecated after Coldfusion 5. But it was apparently brought back to life in ColdFusion 11, amid some confusion.
See for example ColdFusion 11 and dbvarname attribute
In any case, what do your log files say? Do you get any error messages? What brand of database management do you use?
Have you tested whether the values of resultXML and LIVE#companyCode# are what you expect? You could debug your code as follows:
<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#">