[thelist] Check for empty record set?

Anthony Baratta Anthony at Baratta.com
Wed Jun 18 18:14:57 CDT 2003

At 03:48 PM 6/18/2003, Casey Crookston wrote:
>If, just after executing a select statement, i'd like to check and make sure
>it's not empty, how would I do that?
>For example:
>Set var_individual = oConn.Execute("SELECT * FROM employees WHERE

Looks like you are using ASP??

if not(var_individual.EOF AND var_individual.BOF) then

         '' Found some data
         '' Not data found

end if

Anthony Baratta
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."

More information about the thelist mailing list