Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-04 : 19:59:36
|
John writes "I have done a lot of research on presenting tabular data on a web page by breaking up the records by page with usually a goto page # on the bottom ie like any good search feature on a web page. All of the documentation that I have seen seems to suggest to use ADO PageCount properties for a recordset. I have come up with a SPROC that will do the same thing with just passing the page number that you want to see. My SPROC can also order the records back to the web server. If you like I will share this information with your site in hopes that it can help others. I think it is a nice approach over using the ADO Recordset Object which can carry a lot of overhead on your system. I have created this SPROC using SQL Server 7.0.
Thank You
John" |
|
|
|
|
|
Paged Records From a Table