Hi, Im making myself a webBoard(that works like this one) in asp and things are going pretty well.
BUT, I have now bumbed into a problem that I need help with.

First, read and try to understand what want to achive:

strSQL="SELECT (SELECT Forums.Threads FROM Forums WHERE Forums.ID="& Forum &") AS ThreadsCount,"&_
"Threads.ID,Threads.Title,Threads.Author,Threads.LastPostDate,Threads.Status,Threads.DatePosted, Threads.Replies, "&_
"(SELECT Users.UserName FROM Users WHERE Users.ID=Threads.Author) AS ThreadAuthor "&_
"FROM Threads WHERE Threads.Forum="& Forum

this SQL-code fetches the data I want to display on the page where I list all threads, and
it's here my problem is. I do not want ALL threads on one page, after a while it will be full with threads
and if I have let's say 600 threads, the page will be very long, and it will take a while loading it.

So, this is what I want to achive:
I want to display 50 threads a page, and at the bottom it should say something like:
page 1, 2, 3, 4 next>>
I think you get the idea, you can find it almost everywhere!

How do I make this happen if I do NOT want to use objRS.pageSize = x ?
I was more thinking of using 'BETWEEN x AND y' in my SQL-statement but when I do that I get
nowhere near my vision.

the big question is, can this be done or should I choose the other path ?

thanks,
David