[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
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
More information about the thelist
mailing list