By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,581 Members | 2,007 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,581 IT Pros & Developers. It's quick & easy.

Error Type: ADODB.Recordset (0x800A0BCD)

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.