ASP/SQL Question

Results 1 to 3 of 3

Thread: ASP/SQL Question

  1. #1
    MarK Guest

    Default ASP/SQL Question

    Hi all,<BR>When querying a databse for a particular record <BR>i.e WHERE product_id = pro_id. (There will always be a value given for pro_id). Is there anyway of checking for the existence of a record and Redirecting rather than getting the "Either BOF or EOF or record deleted" message?<BR>Thanks! rgds Mark.<BR><BR>

  2. #2
    Paully Guest

    Default RE: ASP/SQL Question

    Yeah, trap it.<BR><BR>You yourself check for the "Either BOF or EOF or record deleted"<BR><BR>By saying<BR><BR>If RstObj.EOF and RstObj.BOF then<BR><BR>Response.Redirect "/someerrorpage.asp"<BR><BR>End if

  3. #3
    Mark Guest

    Default RE: ASP/SQL Question

    Its at these times that I feel really dumb!<BR>Thanks Paully!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts