Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Location
    San Juan, Puerto Rico
    Posts
    29

    Red face Unanswered: BOF or EOF ERROR

    I am getting this error when I press my link for update:

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

    I know it is because the table is empty, I am trying to put the code below so when the user tries to select the update link it takes him to an custom error page that display that there is no data to update.

    My code:
    <%
    If Rs.BOF or EOF then
    response.redirect "entrar_resume.asp?error=3"
    End If
    %>

    Other thing it might work is that the link does not displays if the record on the table is empty, but I don't know how to do this one.

  2. #2
    Join Date
    Sep 2003
    Posts
    4

    hey

    My code:
    <%
    If Rs.BOF or EOF then
    response.redirect "entrar_resume.asp?error=3"
    End If
    %>


    i guess the problem above is in EOF, try this line of code

    If Rs.BOF or Rs.EOF then

  3. #3
    Join Date
    Sep 2003
    Posts
    4

    hey

    also try

    If Rs.BOF And rs.EOF then

Posting Permissions

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