Q5822 How can I tell when my database query returns 0 records?

irt.org | Knowledge Base | ASP | Q5822 [ previous next ]

Q5822 How can I tell when my database query returns 0 records?

From time to time an application will execute a SQL query that's supposed to retrieve something, but doesn't. Whatever the underlying reason, it's important to handle this case.

You should always encapulsate any code that depends on data being returned in a control flow structure (see examples).

<%

' EXAMPLE 1
' LOOP THROUGH SOME RECORDS
' AND WRITE THEIR VALUES TO THE
' BROWSER.  The not RS.EOF MEANS
' NOT YET AT THE END OF FILE

do while not RS.EOF
  response.write RS("fieldName")
loop

' EXAMPLE 2

if RS.EOF then
  response.write "No records were returned"
else
  ' DO SOMETHING WITH THE RECORDS
end if

%>

Feedback on 'Q5822 How can I tell when my database query returns 0 records?'

• August 30, 2001 at 16:14:31: Mike Langford
• 14:46:16 9/28/00 Scott Benner