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

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

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

Logged in as: Guest

arrSession:exec spGetSession 2,3,2811

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> WHy does it show 1 record per page instead of 10?
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

WHy does it show 1 record per page instead of 10? - 4/26/2005 7:28:03 AM

gilgalbiblewheel

Posts: 14
Score: 0
Joined: 4/6/2005
From:
Status: offline

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