Solved

ADODB.Field error '80020009'

Posted on 2016-09-14
5
27 Views
Last Modified: 2016-10-31
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
Comment
Question by:Nur Amirah Roslan
  • 2
5 Comments
 
LVL 52

Accepted Solution

by:
Scott Fell,  EE MVE earned 250 total points
ID: 41799065
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
 
LVL 50

Assisted Solution

by:Ryan Chong
Ryan Chong earned 250 total points
ID: 41799075
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
 

Author Comment

by:Nur Amirah Roslan
ID: 41799082
ok, thank a lot for your suggestion...i will look it forward
0
 
LVL 50

Expert Comment

by:Ryan Chong
ID: 41821033
Do you still need assistance here? is your problem resolved?
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question