Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO recordsets
Message
 
 
To
18/08/1999 11:43:35
General information
Forum:
Internet
Category:
Active Server Page
Title:
Miscellaneous
Thread ID:
00255030
Message ID:
00255635
Views:
10
>I need to display data from an ADO recordset within a web page, via ASP. This I can do, no problem.
>
>What I'm trying to do is reduce the hits to the server.
>
>For instance, I have one ADOR that returns 150 records. The client wants to see 10 records per page with buttons to go to the next/previous pages. Since the recordset is disconnected how do I basically save the recordset to the client and have the next/previous buttons get the data from that source rather than hitting the server over and over again?
>
>Any ideas what I might get this done?
>
>Thanks,
>Michael

Michael,

take a look at http://www.learnasp.com/learn/dbtablepaged.asp It has an example using paged recordsets. This might be a solution to your problem. It's how MS does it on the support site (more or less). They instead us hidden form values, but this gives you a good push in the right direction.

Hugo
"My get up and go must've got up and went"
-Steve Tyler, Aerosmith
Previous
Reply
Map
View

Click here to load this message in the networking platform