Check to see if recordset is empty

[alexkeel79]

How to I check to see if a recordset from a SELECT query is empty? I am getting the following error:

error '80020009'
Exception occurred.

And the only reason I can think of is because I have an if statement that checks a value from a recordset that is empty.

 

[DotNetGnat]

If rs.EOF AND rs.BOF Then
response.write "sorry, no records found"
else
'display your records
end if

BTW that error doesnt seem to me like empty record set...

-DNG

 

[Sheco]

IF (rs.State <> 1_ THEN
Response.Write "Recordset is closed"
ELSE
IF rs.EOF THEN
Response.Write "Recordset is empty"
END IF
END IF

 

[Sheco]

Is it possible that your've got a value but it is Null?

Sometimes you can get an error when you try to use a Null where a string or number is expected.