|
Subject:
|
WHy does it show 1 record per page instead of 10?
|
|
Posted By:
|
gilgalbiblewheel
|
Post Date:
|
4/26/2005 2:22:10 PM
|
http://k.domaindlx.com/gemetria/kjvresp5.asp?page=1&chapter=yes&number=5&recordType=da&text_data=yes&optAction=on
Each page is skipping 20 records. First page shows id # 21944 and page 2 shows 21964.
The next page ( 3rd ) shows:
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:
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
|
|
Reply By:
|
om_prakash
|
Reply Date:
|
4/26/2005 11:06:48 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
|
|
Reply By:
|
gilgalbiblewheel
|
Reply Date:
|
4/27/2005 11:03:47 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.
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:
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
|
