> -----Original Message----- > From: rudy [mailto:r937 at interlog.com] > hope you guys don't mind me butting in here (i am *so* not an ASP > developer), but isn't the question what to do when there are > no records returned from a query? > > where's the test to see if the recordset is empty? Actually, in ASP, that is the test! If the pointer is simultaneously at the beginning and the end of the recordset, then that means no data has been returned. I suppose "If rs.RecordCount > 0" would work just as well, but most tutorials teach the rs.EOF way of doing it. http://www.4guysfromrolla.com/webtech/092398-1.shtml http://www.vbsquare.com/databases/tip421.html