Empty RecordSet and RecordCount
Posted on 2005-03-16
I'm trying to figure something out here...
where empid = ...
<cfif myquery.recordcount GT 0>
Put data here
There is no data found.
If the query returns the empty recordset the cfif statement doesn't recognize any recordcount so the result ends up just being blank. I want the result to be if the query returns an empty recordset, to say that there are no records. What am I missing?