in your SQL statement, do an ORDER BY
For example, I want to sort by last name in alphabetical order, my SQL would
be like
SELECT FirstName, LastName, Address
FROM ClientInfo
Order By LastName
>From: Christine Kelley <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: <cfoutput> lists Alphabetically
>Date: Thu, 12 Apr 2001 17:28:06 GMT
>
>
>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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
