Results 1 to 4 of 4

Thread: Error Code!

  1. #1
    Join Date
    Dec 2003
    Location
    Manila, Philippines
    Posts
    17

    Unanswered: Error Code!

    Hi everyone, can anyone tell me what is the meaning of this error:


    ADODB.Field error '80020009'

    Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

    Thank you..

  2. #2
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    I would have thought the error message was quite obvious but...

    You have a recordset.

    You have reached the start of the recordset or the end of the recordset and have tried to move past the last record (on one end of the other).

    Alternatively the record you are referencing may have been deleted.

    Just as a note BOF = Beginning of file, EOF = End of file.
    Last edited by rokslide; 02-17-04 at 20:52.

  3. #3
    Join Date
    Dec 2003
    Posts
    454
    When you try to get data from the record set, it is better to use

    <%
    If Not RS.BOF AND Not RS.EOF Then
    /* get data from record set */
    End If
    %>

  4. #4
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    or you could even use

    <%
    do while not rs.eof
    ' Do stuff with data
    loop
    %>

Posting Permissions

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