I’ve got an issue with “cfstoredproc”. If it does not return any records, variable in “cfprocresult” does not exist. Should it work like this? I’m on Lucee 18.104.22.168 and MSSQL 2012
It looks like I found the reason. One of the parameters was empty string, but it should be integer. Strange I have not got any errors regarding it.
does it throw an exception if you call it manually via sql management studio?
No, it returns empty rowset