473,324 Members | 2,473 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Error Type: ADODB.Recordset (0x800A0BCD)

Hi!

I have a ASP page that generates an excel report. It works fine if there are
records found, however, if no records are found I would like to call the
below listed function instead of getting the following error that I am
presently receiving:

Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested
operation requires a current record

' Move to the first record
rs.movefirst <------- Errors here
if rs.eof then 'new code

' Start a loop that will end with the last record
do while not rs.eof
...
' Move to the next record
rs.movenext
' Loop back to the do statement
loop
else 'new code
call norecordsfound() 'new code
end if 'new code
%>

Thank you in advance.

Chuck


Jul 19 '05 #1
1 6808
You don't need to use rs.Movefirst anyway, since it'll start at the
beginning. But, your issue is that there are no records in your recordset.

If Not rs.EOF Then
'''your looping code
Else
response.write "There are no records."
End If

Ray at work

"Chuck" <se*********@cfl.rr.com> wrote in message
news:eE****************@TK2MSFTNGP10.phx.gbl...
Hi!

I have a ASP page that generates an excel report. It works fine if there are records found, however, if no records are found I would like to call the
below listed function instead of getting the following error that I am
presently receiving:

Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record

' Move to the first record
rs.movefirst <------- Errors here if rs.eof then 'new code

' Start a loop that will end with the last record
do while not rs.eof
...
' Move to the next record
rs.movenext
' Loop back to the do statement
loop
else 'new code
call norecordsfound() 'new code
end if 'new code
%>

Thank you in advance.

Chuck

Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Tom Petersen | last post by:
I have been copying and pasting code and this has been working, but now I get this error: Error Type: ADODB.Recordset (0x800A0E7D) Operation is not allowed on an object referencing a closed or...
2
by: ramia1983 | last post by:
All i am doing is trying to write info to a access database but iget this error Error Type: ADODB.Recordset (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted....
3
by: pooja1982 | last post by:
Hi, I m getting this message after executing the following code <% CALL OPENDATACON DIM RS SET RS=SERVER.CreateObject ("ADODB.RECORDSET") s="select * from dbpassenger order by ref_no" CALL...
1
by: mudasserrafiq | last post by:
I am using following asp file default.asp <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <META http-equiv=Content-Type content="text/html; charset=windows-1252"> <META content="0...
3
by: dotnetdev1 | last post by:
Hi Friends, Wen I am rying to run my asp application....i am ending up with this following error... Error Type: ADODB.Recordset (0x800A0CC1) Item cannot be found in the...
2
by: colesslow | last post by:
i have these asp files to edit a record in my sql server..but it can't be done. the error is Error Type: ADODB.Recordset (0x800A0E7D) The connection cannot be used to perform this operation. It...
3
Fary4u
by: Fary4u | last post by:
Hi my coding works fine on the net but when i download it to local machine & run the script it's give me this erro ? Error Type: ADODB.Field (0x800A0BCD) Either BOF or EOF is True, or the...
1
by: shivasusan | last post by:
Hi Friends! Please Help me! How i can solve this error? Please explain me, what is the error and how to solve? Error Type: ADODB.Recordset (0x800A0E7D) The connection cannot be used to...
2
by: rashmi wadhwa | last post by:
<% dim conn,rs set conn=Server.createobject("ADODB.Connection") set rs=Server.createobject("ADODB.RecordSet") conn.Open "Provider=SQLOLEDB;Persist Security Info=False;User Id=sa;Initial...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.