if search comes up empty

abbylee26 · October 3rd, 2003, 01:29 PM

How can I tell if a search on the db comes up empty so I can handle it?

Imar · October 4th, 2003, 02:23 AM

Are you using ASP with ADO and use a recordset to get the data from your database? You're not providing much information about your situation, so I'll assume the above is true.

In this case, you can use the .EOF (End Of File) property of the recordset:

Code:

' Create and open recordset here
If Not MyRecordset.EOF Then
  ' Do something with the records
Else
  Response.Write("Sorry, no records found")
End If

Does this help?

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

zaeem · October 4th, 2003, 03:58 AM

Hello ur answer benefited me a lot. If I want to check that my recordset returns Null I want to check it within the <% do while not r.eof%> how can I check it out here.Waiting to have reply.
Bye

Zaeem Sherazi

Imar · October 4th, 2003, 04:45 AM

Well, you can check for EOF first, and if the recordset is not EOF, do your While loop:

Code:

' Create and open recordset here
If Not MyRecordset.EOF Then
  Do While Not MyRecordset.EOF
    ' Do something with the record from the recordset
    Response.Write("Value is " & MyRecordset("MyColumn"))
    ' Move to the next record
    MyRecordset.MoveNext()
  Loop
Else
  Response.Write("Sorry, no records found")
End If

HtH,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.