[thelist] Check for empty record set?

[Casey Crookston]

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)

The user has the option to scroll through a list of employees, and as he/she
does so it uses the emp_id as the search key.  Now, if by chance this
employee has quit or been fired, this SQL will return nothing.  At this
point, how can I check to see if var_individual has something in it.

Thanks,

Casey