Detecting an empty recordset?

[tycaine]

As the subject suggests, I need to know how to detect an empty recordset.

In the DB I'm using there are three possible ways to find data, I need to search through the database first one way to see if there are any records, if none go to the second way and search to find records, if none move onto the third way...

Any help would be appreciated...

Thanks in advance!

T.C.

 

[tycaine]

Ok, figured it out...

if (oRS.bof = true and oRS.eof = true) then
	response.write("Empty RecordSet")
else
	response.write("Display RecordSet Info")
end if

Thanks anyway, hope this helps someone!

T.C.