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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-24 : 17:15:45
|
Kevin writes "Hi,
I have a web project that has a listing of over 10,000 different businesses. Users can select businesses by business categories( ie Doctors). I limit each page to show only 30 alphabetically sorted records per page view and I provide a "First, Prev, Next, Last" option at the bottom of the page so that they can navigate the selected recordset. If the recordset has 400 records, clicking "next" a bunch of times to get to the "T's" listings (for example) quickly becomes cumbersome.
Using ADO and the ADO's pagecount, I can easily add links to each page number of the recordset(ie 1 2 3 4), however, what I want to do is add linkable letters (ie A B C D E F G....) that the user can click on to quickly jump to a businesses name if they know the first letter of the business name (ie if they want to go to "Thompson", they can click on the "T" and be taken to the first listings of the "T's".
Do you have any idea how I can accomplish this?
Thanks,
Kevin
SQL Server 7.0" |
|
|
|
|
|
Select by first letter