|
 |
asp_web_howto thread: Alphabet Listing of Recordset
Message #1 by "David Yee" <david@r...> on Sun, 16 Dec 2001 11:33:16 +0800
|
|
Can i know how do i create a naviagtion bar for
retrieving the records using Alphabet order instead
of page number.
I need to create something like this.
A | B | C | D | E | F | G | H | I | J | K |
When the user click on A, it will retrieve only record starting
with A. Do i have to write the coding manually for all the link
like
<A href="...?start=A"> A </A>
<A href="....?start=B"> B </A>
Or is there a better method? Please advice.
Thank You.
Message #2 by Greg Griffiths <griffiths@x...> on Sun, 16 Dec 2001 14:40:59 +0000
|
|
As you have posted this to an ASP list, i assume that you will be using ASP
probably with a database, so you could use the LIKE statement :
SELECT * FROM myTable WHERE siteTitle LIKE "a%"
At 11:33 16/12/01 +0800, you wrote:
>Can i know how do i create a naviagtion bar for
>retrieving the records using Alphabet order instead
>of page number.
>
>I need to create something like this.
>A | B | C | D | E | F | G | H | I | J | K |
>
>When the user click on A, it will retrieve only record starting
>with A. Do i have to write the coding manually for all the link
>like
> <A href="...?start=A"> A </A>
><A href="....?start=B"> B </A>
>
>Or is there a better method? Please advice.
>
>Thank You.
>
>
|
|
|
View Cart
