|
I don't understand ... what's the issue with 10 items? I would have thought you'd have a problem with a column named name, and have to use square brackets like select [name] from someTable ... it sounds more like you're trying to do something like Google, where you get millions of results but they come ten per page?
If that's the case, you want to read the data out of Access and put it into an array instead of directly outputting it to the page. Then you store this in a session variable - maybe an application variable instead if it'll always be the same for every user at any given point. Finally, the page itself needs to get the data from the session or application variable and output that to the page.
So, your first page will show your first ten items from the cache, with a link at the bottom saying "next ten results" or whatever, that points to the same page with query string parameters telling you which range of items to pull from the session variable you created. This will have the side effect of speeding the site up a little, especially if you can store your data at the application level instead of by session. But then when you run an "action query" you need to either update or clear the cache.
Well ... if that's what you were asking about, the good folks here can help you break that down and figure out how to implement each step. If not, then it's something else...
|
