Alphabetic list 1

[joakimhan]

I got a problem that i hope someone can please help me with.
I got a database with names and url and languageid that i want to make to an alphabetic list

<CFQUERY NAME=&quot;getDomain&quot; DataSource=&quot;mysource&quot;>
SELECT name, url, langid
FROM domain
</cfquery>

I want to order my list as an alphabetic list something like this

A
ABCnews abcnews.go.com
AdWeek

http://www.adweek.com

Advertising Age

http://www.adage.com

Back to top

B
BBC News news.bbc.co.uk
Bloomberg

http://www.bloomberg.com/bbn/

Brandweek

etc

I can make it as an alphabetic list but how do I make it with the heading for every Character in the alphabet.

Hope someone can help me

Best Regards
Joakim Han

 

[CFHub]

A little GROUPing should help.

<CFQUERY NAME=&quot;getDomain&quot; DataSource=&quot;mysource&quot;>
SELECT
name,
url,
langid,
Right(name,1) AS FirstChar
FROM domain
GROUP BY
FirstChar
</cfquery>

<cfoutput query=&quot;&quot; group=&quot;&quot;>
#FirstChar#
<cfoutput>
#name# #Url#
</cfoutput>
</cfoutput>

 

[CFHub]

DOH,

make that: Left(name,1)

 

[CFHub]

Need coffee and an edit button

<CFQUERY NAME=&quot;getDomain&quot; DataSource=&quot;mysource&quot;>
SELECT
name,
url,
langid,
Left(name,1) AS FirstChar
FROM domain
GROUP BY
FirstChar
</cfquery>

<cfoutput query=&quot;getDomain&quot; group=&quot;FirstChar&quot;>
#FirstChar#
<cfoutput>
#name# #Url#
</cfoutput>
</cfoutput>

 

[joakimhan]

Thank you very much.
I appreciate the help.

Joakim