Do it in your SQL.
ORDER BY LastNameColumn
Then, do your group buy
Dave
----- Original Message -----
From: "Christine Kelley" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, April 12, 2001 1:28 PM
Subject: <cfoutput> lists Alphabetically
>
> Hi!
> How do I output a whole list of names from a query
> grouped alphabetically? Output example:
>
> A
> Allen, Bob
> Ames, John
>
> B
> Book, Sam
> Briant, Max
>
> I'm thinking it's by somehow using the group attribute of
> the <cfoutput> tag or looping through the query, but I'm
> not sure exactly how to get these results.
>
> Thank-you for any help!
> Christine
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
