ADODB.Field error '80020009'

Hi...i have a problem where this error come out when i am trying to run my code...i used asp for this code:

ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/servisdesk2.0/dashboard/maindev.asp, line 0

i have run this code before and it work it this problem caused by server problem
Who is Participating?
Scott Fell, EE MVEConnect With a Mentor Developer & EE ModeratorCommented:
It means there is no data being returned in your recordset.

If you have a table with columns A and data looks like


Then you have a query SELECT ColumnA from MyTable where ColumnA = 3 there is no data and you will get that same error.

I hope this helps to make sense.
Ryan ChongConnect With a Mentor Commented:
always do a check to handle your scripts before you referring to a Recordset's field data, like try to add this before that:

if rs.eof then
    response.write "no record was found or you should do some error handling here " 
end if

Open in new window

NurAuthor Commented:
ok, thank a lot for your suggestion...i will look it forward
Ryan ChongCommented:
Do you still need assistance here? is your problem resolved?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.