I would start by coding it this way.
The select statement to create the letters would be:
SELECT DISTINCT upper(left(LastName, 1))
FROM Name
ORDER BY upper(left(LastName, 1))
Then I would look through the resulting query to create the actual links.
The HREF for each letter would have a URL variable called WHERE and it would
be eaqual to the letter (i.e. ?WHERE=A)
The ALL Link would not have a WHERE URL variable
The page each link called would use the following logic:
<cfif NOT isDefined("URL.WHERE)>
<CFQUERY....
SELECT *
FROM Name
<cfelse>
<CFQUERY...
SELECT *
FROM Name
WHERE LastName LIKE '#URL.WHERE#%'
</cfif>
and display the names, etc.
Hope this helps.
Russel
============================================================
Russel Madere, Jr. Senior Web Developer
ICQ: 5446158 http://www.TurboSquid.com
Some days you eat the bear; some days the bear eats you.
============================================================
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 26, 2001 10:14
> To: CF-Talk
> Subject: Alphabetic List
>
>
> Hi,
>
> In Yahoo address book, they have this list for finding a particular
> person easily
> by the first letter of their last name:
>
> All - A B C D E F G H I J K L M N O P Q R S T U V W X Y Z - Lists
>
> Does anyone have any insights on how the algorithm of implementing this
> feature?
>
> For example, I have a user database, and I want to use this feature to
> find
> persons whose last name start with a particular letter.
>
> Thanks!
>
> Hong
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists