[thelist] Check for empty record set?
Ken Kogler
ken.kogler at curf.edu
Wed Jun 18 18:04:07 CDT 2003
> 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)
This looks like ASP. In that case, this would work:
If var_individual.bof and var_individual.eof then
' rs is empty
Else
'print the records
End if
HTH!
--ken
More information about the thelist
mailing list