[thelist] Check for empty record set?

Casey Crookston casey at thecrookstons.com
Wed Jun 18 17:48:34 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

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.



More information about the thelist mailing list