Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 59
  • Last Modified:

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 well....is it this problem caused by server problem
0
Nur
Asked:
Nur
  • 2
2 Solutions
 
Scott Fell, EE MVEDeveloperCommented:
It means there is no data being returned in your recordset.

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

4
6
8
12

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.
0
 
Ryan ChongCommented:
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 " 
    response.end
end if
...
%>

Open in new window

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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now