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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 results per page asp

Author  Topic 

alxtech
Yak Posting Veteran

66 Posts

Posted - 2006-07-06 : 12:18:37
Hello forum:
I have a asp page application that queries a sql 2005 database, it displays the results in the asp page but sometimes the results are very long and it takes a long time to scroll down to the page.
Question:
I do i break the results into multiple pages example.
results page 1 of 10 with a maximun of display entries to a fixed number
thank you for your help.

RyanRandall
Master Smack Fu Yak Hacker

1074 Posts

Posted - 2006-07-06 : 12:45:55
google is your friend...

http://www.google.com/search?hl=en&q=paging+%22sql+2005%22


Ryan Randall
www.monsoonmalabar.com London-based IT consultancy

Solutions are easy. Understanding the problem, now, that's the hard part.
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-07-06 : 16:11:52
read up on recordset paging.

If you have dreamweaver, It also does a good job for you
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-07-07 : 01:06:23
http://weblogs.sqlteam.com/jeffs/archive/2003/12/22/672.aspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -