Connecting Tech Pros Worldwide Forums | Help | Site Map

How to solve this error?

Newbie
 
Join Date: Jun 2007
Posts: 14
#1: Jul 2 '07
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's Avatar
Expert
 
Join Date: Jul 2006
Posts: 250
#2: Jul 2 '07

re: How to solve this error?


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

Expand|Select|Wrap|Line Numbers
  1. rs.Open strSQL, oCn, 1, 1
  2. if rs.EOF then
  3.     response.write "No records found"
  4.     'don't try to read any fields
  5. else
  6.     response.write "records found..."
  7.     'proceed as normal
  8. end if
codegecko's Avatar
Moderator
 
Join Date: May 2007
Location: United Kingdom
Posts: 395
#3: Jul 2 '07

re: How to solve this error?


Quote:

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
Newbie
 
Join Date: Dec 2007
Posts: 1
#4: Dec 31 '07

re: How to solve this error?


[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,line390
Newbie
 
Join Date: Dec 2007
Posts: 17
#5: Jan 1 '08

re: How to solve this error?


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


http://aspspider.info/magicalspell4u/?Quest=ADODBFieldError

-Thanks
52
Newbie
 
Join Date: Dec 2007
Posts: 26
#6: Jan 2 '08

re: How to solve this error?


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