paging query results

[Piz Bruin]

I have a web based app that querys a MS-SQL database. Sometimes the results of the users query is very large & creates a page that is way too long.

How can I break up the results into smaller pages, kind of like you get with the popular search engines. A page list at the bottm of each page like:

Page 1 - 2 - 3 - 4 - Next>>

Thanks!!!

Well, I just use a for-next loop to display X results, and if someone clicks the next or previous arrow (or number) I just pass a parameter along and according to what value the parameter has, I display the results belonging to that page.

But I'm sure there is a shorter and more efficient way.

Marcel