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

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)
%>

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