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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Start reading from n-th record?

Author  Topic 

GattoGrigio
Starting Member

1 Post

Posted - 2008-07-06 : 16:42:21
I need to write an application in ASP, where I SELECT a number of rows from a database, and then I page through the results, ten at a time on each resulting HTML page. When the user selects the 2nd (3rd etc) page, I need to jump directly to the 11-th (21st etc) record in the SELECTed subset of records.

How do I do it?

Thanks in advance,

Stefano, Zürich

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-07-06 : 21:15:22
see http://www.sqlteam.com/article/server-side-paging-using-sql-server-2005


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -