[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
  'print the records
End if



More information about the thelist mailing list