irt.org FAQ Knowledge Base Q5822
Mike Langford on August 30, 2001 at 16:14:31:
A better way I have found is to simply do:
if rs.BOF and rs.EOF then
Response.Write("No Records Returned")
'Do something with the returned records
Checking for both the EOF and the BOF will ensure that the rs is really empty since you can only be at the end AND the beginning at the same time when there is nothing in the set.
Other feedback on 'irt.org FAQ Knowledge Base Q5822' - show all