casey.... what's the db you're using..... in mysql, you can check the number of records returned from the query... i assume your db API permits something similar... bruce -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Casey Crookston Sent: Wednesday, June 18, 2003 3:49 PM To: thelist at lists.evolt.org Subject: [thelist] Check for empty record set? 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 -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ Evolt.org conference in London, July 25-27 2003. Register today at http://evolt.org.uk For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !