Question
recordcount on str.Proc. result
When my str. Proc. returning a query result and I use cfdump to see the resultset I can see it displays in my screen just fine.
but if the result of str. proc. is 0 my code throw an error :
Element RECORDCOUNT is undefined in Q_my_strproc_name.
The error points to the following code:
<cfif Q_my_strproc_name.recordcount NEQ 0>
......etc
How can I prevent error when the str proc. does not return any result if I can't use Q_my_strproc_name.recordcount?
Thank you for any help.