What exactly are you wanting this tag to do? This code should give you a
list like
A
Apple
B
Banana
Berry
G
Grapefruit
Grapes
<cfquery name="getFruit">
SELECT LEFT(name, 1) AS firstLetter, name
FROM Fruit
ORDER BY firstLetter, name
</cfquery>
<cfoutput query="getFruit" group="firstLetter">
#getFruit.firstLetter#
<p>
<cfoutput>
#getFruit.name#<br>
</cfoutput>
<br>
</cfoutput>
Duncan Cumming
IT Manager
http://www.alienationdesign.co.uk
mailto:duncan.cumming@;alienationdesign.co.uk
Tel: 0141 575 9700
Fax: 0141 575 9600
Creative solutions in a technical world
----------------------------------------------------------------------
Get your domain names online from:
http://www.alienationdomains.co.uk
Reseller options available!
----------------------------------------------------------------------
----------------------------------------------------------------------
"Robertson-Ravo, Neil (REC)"
<[EMAIL PROTECTED] To:
"'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
dexpo.com> cc:
Subject: [ cf-dev ] A-Z
listing
10/28/02 03:04 PM
Please respond to dev
Anyone got a link for a decent A-Z listing Tag? I need to implement one
fairly quickish and I was hoping there are a few tags out there!
Neil
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
