www.webdeveloper.com
Results 1 to 2 of 2

Thread: asp error message

  1. #1
    Join Date
    Feb 2006
    Posts
    7

    asp error message

    hello all,

    I enter a number which does not exists in the database hence
    I am getting the below message because i know my recordset is empty.

    ADODB.Field (0x80020009)
    Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

    is there a way i get a message box saying ur number does not exist instead of the above error.

    any help is appreciated.

    thank you

    raineel

  2. #2
    Ubik's Avatar
    Ubik is offline <%= "New Meja Hor" %>
    Join Date
    Nov 2005
    Location
    Earth
    Posts
    361
    check for BOF or EOF prior to manipulating the recordset:

    PHP Code:
     if not rs.BOF and not rs.EOF then
      
    'manipulate recordset
     else
      response.write "<p>Bummer, dude, no records found.</p>"
     end if 
    --Ubik

    If I have no idea what you are talking about, then I will pretend I know and answer accordingly.

    Thinking about starting a New Thread entitled 'Please Help Me!' ? Read this!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles