when I click next page it says
Quote: SELECT * FROM bible WHERE
Microsoft OLE DB Provider for ODBC Driverserror '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in WHERE clause. /bible7.asp, line 473 ...
One of the problems is that I 've asked to give 20 records per page but the records DO start with an increment of 20 but then go all the way to the end. In other words the first is from #1 all the way to the end. The 2nd is from #21 all the way to the end...
View Replies View RelatedI've been record paging with the Recorset object for a while now with 99% success.
When I've set a page length and start page on the recordset the bookmark will start at the proper record, but will not report EOF at the end of that page, so I end up having to KLUDGE it up a bit with a variable that counts out how many records have been processed and exit the loop. I'll toss some code down there to show you what I mean; the KLUDGE is labled KLUDGE with a comment
Is there either a property that I'm not setting properly on the recordset or something that I'm missing that will make the recodset object report EOF as it should or "End of Page" or what ever?
Do you know any good codes on "pageing"?
View Replies View RelatedDo you know any good codes on "pageing"?
View Replies View Related