Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Active Server Pages (ASP)
Expertise: Beginner
Aug 12, 1999



Building the Right Environment to Support AI, Machine Learning and Deep Learning

ASP Scrolling Through a Resultset

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.

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.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date