[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