how to -- querystring not found error msg

[cindy0904]

Hi, I have 2 pages. One passes a user input one-line text field to the second page (request.form). It all works great IF the user enters a valid number that matches the DB. BUT, if they put in anything else, the second page displays the basic BOF/EOF error. Where and what code can I use to display a blurb, "sorry, not found.." ????

Thanks!
Cindy

 

[FateFirst]

If not objRecordSet.eof then
<<DO WHATEVER>>
Else
Response.Write(&quot;Sorry, no record found!&quot
End if

- FateFirst

 

[cindy0904]

Ah, yes, I had tried that and my problem was I had a field left out that was still causing the problem. I needed to encompass all fields. Thanks for the reply!