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)
 Paging an alphabetical result set

Author  Topic 

MikeR
Starting Member

2 Posts

Posted - 2002-04-25 : 05:06:02
I would like to display a list of items from a SQL Query in a "paged" format, with 1-10 11-20 21-27 links underneath. Alongside this I have an A-Z index which will jump to the relevant place in the list.

Has anyone achieved this without reams and reams of code and many separate stored procedures?

Mike

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2002-04-25 : 05:17:08
If you're using VB with ADO, there is a way you can 'page' the recordsets. This can be used in an ASP page with no problems. Check out an ADO reference for details

Go to Top of Page
   

- Advertisement -