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

[gilgalbiblewheel]

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:

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:
SELECT * FROM hebbooktable INNER JOIN hebrewbibletable ON hebbooktable.book = hebrewbibletable.book WHERE chapter LIKE '5' AND (recordType = 'da') ORDER BY id ASC

[iShopHQ]

it seems to me that there are only 2 records that match your query. when you go to page 3, there's no record there and you get the error.

look into how you are doing your dynamic links and recordset paging