Re: separating alpha groups in query results

[DougF]

Thanks Ian,

Got it to work with:
-----------
<cfset firstLetter = "A">
<cfloop query="get_location">
    <cfif Left(city_name,1) NEQ firstLetter>
        &nbsp;
        <cfset firstLetter = left(city_name,1)>
    </cfif>
<cfoutput><p>#city_name#</p></cfoutput>
</cfloop>
-----------

DougF

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---