One simple way is to add a column to your query with the initial letter
(something like "LEFT(column, 1) AS initial") and then <CFOUTPUT GROUP>
using that column.
--- Ben
-----Original Message-----
From: DougF [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 1:34 PM
To: CF-Talk
Subject: separating alpha groups in query results
Want to insert a blank line separator at the start of each new alpha
letter
group
in a looped display query result. Any suggestions?
DougF
-----------------
Example:
Ajo
Amado
Apache Junction
Arizona City
Ash Fork
<blank line here>
Benson
Bisbee
Black Canyon City
<blank line here>
Camp Creek
Cottonwood
------------------
_____
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]