How to solve this error?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • karenkksh
    New Member
    • Jun 2007
    • 15

    How to solve this error?

    ADODB.Field error '800a0bcd'

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

    /MSS/Feedback/FeedbackB.asp, line 61
  • danp129
    Recognized Expert Contributor
    • Jul 2006
    • 323

    #2
    it really depends on the context... After opening a recordset you should check that it's not empty before continuing like so:

    [CODE=asp]rs.Open strSQL, oCn, 1, 1
    if rs.EOF then
    response.write "No records found"
    'don't try to read any fields
    else
    response.write "records found..."
    'proceed as normal
    end if[/CODE]

    Comment

    • JamieHowarth0
      Recognized Expert Contributor
      • May 2007
      • 537

      #3
      Originally posted by karenkksh
      ADODB.Field error '800a0bcd'

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

      /MSS/Feedback/FeedbackB.asp, line 61
      Hi there,

      This can be due to a number of things:
      You may not have any records in your table.
      You may have mis-typed a field name or table name within your SQL query. Double-check all spellings of field names and tables used.
      You may have accidentally used a reserved word (e.g. "external") which will kick up an error within the query.

      Hope this helps,

      medicineworker/MPDDK-mm4

      Comment

      • annakim
        New Member
        • Dec 2007
        • 1

        #4
        [QUOTE=karenkksh]ADODB.Field error '800a0bcd'

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

        /eprolFP/webPage/infoEntry/infoEntry.asp,l ine390

        Comment

        • alijannaty52
          New Member
          • Dec 2007
          • 17

          #5
          After searching to solve your prob. Hope the below link will help you indeed.


          http://aspspider.info/magicalspell4u/?Quest=ADODBFie ldError

          -Thanks
          52

          Comment

          • change
            New Member
            • Dec 2007
            • 26

            #6
            use a response.write (the value that u want) to check whether the value is there

            Comment

            Working...