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: This is the SQL:
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