TallyList : mailing list management, archiving, and analysis

Archive of:
CF-Talk
Cold Fusion - Technical

home
24 hour view
quick stats
weekly updates

all tallylists
corporate solutions
archive your favorite
help / feedback

About Cold Fusion :
product's home
product's list home

Archived TallyList / CF-Talk:
Subject: RE: <cfoutput> lists Alphabetically

Peter Stolz (16p/+0r) Posted: Thursday 12 Apr 2001
This post: 85 views, +0 rating

Try,

<CFQUERY NAME="q" DATASOURCE="#DSN#"> SELECT *, SUBSTRING(lname,1,1) AS FirstLetter FROM MyTable ORDER BY FirstLetter </CFQUERY>

<CFOUTPUT QUERY="q" GROUP="FirstLetter"> #FirstLetter# <CFOUTPUT> #lname#, #fname# </CFOUTPUT> </CFOUTPUT>

HTH

-----Original Message----- From: Christine Kelley [mailto:ckelley@zeninternet.com] Sent: Thursday, April 12, 2001 1:28 PM To: CF-Talk 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

Similar Subject Line Posts (+/- two weeks of this post)

RE: <cfoutput> lists Alphabetically	13 Apr 2001	(55 v/ +0 r)
RE: <cfoutput> lists Alphabetically	12 Apr 2001	(49 v/ +0 r)
RE: <cfoutput> lists Alphabetically	12 Apr 2001 (this post)	(85 v/ +0 r)
Re: <cfoutput> lists Alphabetically	12 Apr 2001	(47 v/ +0 r)
RE: <cfoutput> lists Alphabetically	12 Apr 2001	(46 v/ +0 r)
RE: <cfoutput> lists Alphabetically	12 Apr 2001	(42 v/ +0 r)
RE: <cfoutput> lists Alphabetically	12 Apr 2001	(50 v/ +0 r)
Re: <cfoutput> lists Alphabetically	12 Apr 2001	(44 v/ +0 r)
RE: <cfoutput> lists Alphabetically	12 Apr 2001	(54 v/ +0 r)
RE: <cfoutput> lists Alphabetically	12 Apr 2001	(41 v/ +0 r)
RE: <cfoutput> lists Alphabetically	12 Apr 2001	(42 v/ +0 r)
RE: <cfoutput> lists Alphabetically	12 Apr 2001	(49 v/ +0 r)
Re: <cfoutput> lists Alphabetically	12 Apr 2001	(51 v/ +0 r)
RE: <cfoutput> lists Alphabetically	12 Apr 2001	(52 v/ +0 r)
<cfoutput> lists Alphabetically	12 Apr 2001	(45 v/ +0 r)

Send a reply to the CF-Talk list!
	NOTE: Many lists will reject your post unless you have already registered with them. Also - don't forget the right account to send from (for those with multiple emails!)