Tris works in SQL. I am sure there maybe a better way but here is one
example:
<cfquery name="GetlastNames" datasource="blahblah">
Select Left(Last_Name,1) as LastInit
From Members
Group By Left(Last_Name,1)
Order by LastInit
</cfquery>
<cfoutput query="getlastnames">
<a href="blah">#lastInit#>
</cfoutput>
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 26, 2001 11:42 AM
To: CF-Talk
Subject: Re: Alphabetic List
Thanks for your replies.
I think I didn't elaborate the question clearly.
What I need is to output the list:
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
If there are persons last names start with "B", B should be a hot link.
If there is no one's last name starts with "Q", Q is not clickable.
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
