Pages in ASP

Hi all

In ASP what's the best way to do pages, for example in a forum?  Sort of like, page 2, 3, 4.

When you click on a page is needs to select a range of records, any easier way of doing this than the method I am doing?  I select the upper record, so if its 10 on each page, on page 3, i select 30, and loop through until I hit 20 before displaying.  Is there anyway to select a range of records?  The mroe pages there are, the longer each one takes to load.

So sort of like:

SELECT RECORDS 10 to 20 FROM tblReplies WHERE topicID = 33


Edited by Gullanian - 27 July 2005 at 10:38am

Isn't it just better to do it in ASP.NET now?  

Just do a search for music slow down err... no... not that... I meant for "asp paging" or "paging ASP" or something like that...

But I still won the Best Application Using .Net Yeah for me

And yes - that was pathetic, but I'm still totally thrilled about it.

As Bluefrog mentioned, it's always best to do whatever in .NET, but if you are like me, still very much tied to classic ASP, classic ADO provides methods for paging, check this:

http://www.asp101.com/articles/recordsetpaging/index.asp

You find many more if you google for [ASP paging].

By the way, congrats froggy on your award, well done.

Edited by theSCIENTIST - 28 July 2005 at 12:57am

He got one already, but there's no blue frog.

What about something like this:


It's very difficult to design for such low resolution as 64x64, but I think it would suit you ok. Design based on this frog that I painfully cut:


If you want it, I can send you the full-res PSDs.