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]

Reply via email to