Cfstoredproc with no records

dev
1

Hi all.
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 5.3.5.92 and MSSQL 2012
Thanks.

2

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.

3

does it throw an exception if you call it manually via sql management studio?

4

No, it returns empty rowset