Question:
How can I display groups of records (for example, the first 10 records), then allow the user to click Next to display the next set of records? I have tried leaving the resultset/connection open, but I can’t seem to reattach to it.
Answer:
You cannot reuse the recordset efficiently. Your best way out is to program your SQL retrieval code so that it only brings back the records you need, by passing some sort of a begin or end marker. So the first time you ask for Record 1 plus the next nine records. The next time, you ask for a set of records beginning at Record 10 and so on.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
