[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
>emp_id="&empid)

Looks like you are using ASP??

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

         '' Found some data
else
         '' Not data found

end if


---
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."



More information about the thelist mailing list