Help ASP Error Mesage

When I want to access .asp file I’m getine this error message “
ADODB.Recordset error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record
error in line 42 or 47


Can somebody tell me what is going on?.

here is part of code

Set rs = Server.CreateObject("ADODB.Recordset")

41 If Len(Request("pagenum")) = 0 Then
42 rs.AbsolutePage = 1
43 Else
44 If CInt(Request("pagenum")) <= rs.PageCount Then
45 rs.AbsolutePage = Request("pagenum")
46 Else
47 rs.AbsolutePage = 1
48 End If
49 End If

Thanks
Daniela

 

It means that there are no records. You've probably reached a "page" where there are no records.

Recordset paging like this is terribly inefficient. This requires you to snapshot the entire recordset which is costly.

Try using a stored procedure to do this.
Read this:http://weblogs.asp.net/pwilson/archive/2003/10/10/31456.aspx

 

You were right. Problem was in the database. There were some files missing…
Thank you so much
Daniela