WHy does it show 1 record per page instead of 10?

gilgalbiblewheel · April 26th, 2005, 02:22 PM

http://k.domaindlx.com/gemetria/kjvr...s&optAction=on
Each page is skipping 20 records. First page shows id # 21944 and page 2 shows 21964.

The next page ( 3rd ) shows:

Quote:

quote:
ADODB.Field error '80020009'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/gemetria/kjvresp5.asp, line 0

This is the SQL:

Quote:

quote:SELECT * FROM hebbooktable INNER JOIN hebrewbibletable ON hebbooktable.book = hebrewbibletable.book WHERE chapter LIKE '5' AND (recordType = 'da') ORDER BY id ASC

Martial Law 9/11 Rise of the Police State is now available! Visit our Martial Law movie section for complete info (click here), or order now by clicking the button below or by calling 888-253-3139
http://www.infowars.com/martial_law_911.htm

om_prakash · April 26th, 2005, 11:06 PM

The error which you specified is coming because, you are trying to access some data after closing the recordset.

Please provide some more information like about pagination code?

Om Prakash

gilgalbiblewheel · April 27th, 2005, 11:03 AM

I have the database table open and have found it by searching it myself.

But to help you out, since the full code in the file is long, I think this is where something goes wrong.

Code:

    If Len(Request("page")) = 0  Then
        rs.AbsolutePage = 1
      Else
        If CInt(Request("page")) <= rs.PageCount Then
            rs.AbsolutePage = Request("page")
          Else
            rs.AbsolutePage = 1
        End If
    End If

    Dim abspage, pagecnt
      abspage = rs.AbsolutePage
      pagecnt = rs.PageCount

I also think there is something wrong in this section:

Code:

if rs.bof and rs.eof then
       Response.Write "No records found!"
Else
    If Not rs.EOF Then%>
       <center>
       <form>...

Because when the search cannot find a query it shows error.

Martial Law 9/11 Rise of the Police State is now available! Visit our Martial Law movie section for complete info (click here), or order now by clicking the button below or by calling 888-253-3139
http://www.infowars.com/martial_law_911.htm