Feedback on: irt.org FAQ Knowledge Base Q5822

irt.org | About | Feedback | 3113 [ previous next ]

Feedback on:
irt.org FAQ Knowledge Base Q5822

Sent by
Mike Langford on August 30, 2001 at 16:14:31:

Worth:
Worth reading

Comments:
A better way I have found is to simply do:

if rs.BOF and rs.EOF then
Response.Write("No Records Returned")
else
'Do something with the returned records
end if

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

• irt.org FAQ Knowledge Base Q5822 - Mike Langford August 30, 2001 at 16:14:31:
• irt.org FAQ Knowledge Base Q5822 - Scott Benner 14:46:16 9/28/00