Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Error Type: ADODB.Recordset (0x800A0BCD)

Reply
Thread Tools

Error Type: ADODB.Recordset (0x800A0BCD)

 
 
Chuck
Guest
Posts: n/a
 
      10-21-2003
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




 
Reply With Quote
 
 
 
 
Ray at
Guest
Posts: n/a
 
      10-21-2003
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" <(E-Mail Removed)> wrote in message
news:eEWY06%(E-Mail Removed)...
> 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
>
>
>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xffc Thread 0x228 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 0 03-30-2006 03:16 PM
Error connecting to SQLExpress 2005 locally (error: 26 - Error Locating Server/Instance Specified) hfk0 ASP .Net 2 03-27-2006 08:43 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8fc Thread 0x934 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 1 03-24-2006 04:20 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8fc Thread 0x934 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 0 03-24-2006 02:22 PM
Error 500: ERROR: Cannot forward. Writer or Stream already obtained. Error JavaQueries Java 1 03-01-2005 06:30 PM



Advertisments