[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