Either BOF or EOF is True, or the current record has been deleted.

This site is best viewed in a modern browser with JavaScript enabled.

Either BOF or EOF is True, or the current record has been deleted.

JoNRTW

Hi,

I'm trying to update a database, when I am getting the error:

ADODB.Field

error '800a0bcd'

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

/admin/edit_product.asp, line 139

The line in question is:

<%
Dim doc1, doc2, doc3, doc4, doc5

[B]doc1=(rs_prod_details.Fields.Item("prod_doc1").Value)[/B] - line 139
doc2=(rs_prod_details.Fields.Item("prod_doc2").Value)
doc3=(rs_prod_details.Fields.Item("prod_doc3").Value)
doc4=(rs_prod_details.Fields.Item("prod_doc4").Value)
doc5=(rs_prod_details.Fields.Item("prod_doc5").Value)
%>

Not really sure on what the problem could be here. Can anybody offer any assistance?
Thanks in advance.

gk53

you trying to read value from recordset, but your recordset is empty....
you should always chaeck for end of file property on recordset as below

<%
Dim doc1, doc2, doc3, doc4, doc5
if not rs_prod_details.EOF then
doc1=(rs_prod_details.Fields.Item("prod_doc1").Value) - line 139
doc2=(rs_prod_details.Fields.Item("prod_doc2").Value)
doc3=(rs_prod_details.Fields.Item("prod_doc3").Value)
doc4=(rs_prod_details.Fields.Item("prod_doc4").Value)
doc5=(rs_prod_details.Fields.Item("prod_doc5").Value)
end if
%>

JoNRTW

Hi,

Many thanks for your reply. I've put this in place and the error still persists. The page is a form which is pre-populated, saving the details back into an Access database. Any more ideas please? Thanks

gk53

Are you still have error on the same line?
try just add before line with error

response.write rs_prod_details.EOF
response.flush
response.end

if should print on screen false
if it is
change code to

response.write rs_prod_details("prod_doc1")
response.flush
response.end

and make sure it is printed value