have a webpage that calls a stored procedure, it worked fine in sql 2005 but we upgraded to MS SQL 2016 last week and now I get the "Invalid character value for cast specification ..". nothing has changed in the data table.
Sorry not sure what happened so will try the post again.
This does NOT work.
cfstored proc procedure="sp_ReturnLeases" DATASOURCE="Wells" RETURNCODE="NO"
CFPROCRESULT NAME = OOPS4
CFPROCPARAM TYPE="IN" CFSQLTYPE=CF_SQL_INTEGER VALUE="#Data[nC]#" DBVARNAME=@iLoc