Best is probably a query. For example:
<cfset myQuery = QueryNew("letter,title")>
<cfset QueryAddRow(myQuery)>
<cfset QuerySetCell(myQuery, "letter", "A")>
<cfset QuerySetCell(myQuery, "title", "Title")>
<cfset QueryAddRow(myQuery)>
<cfset QuerySetCell(myQuery, "letter", "A")>
<cfset QuerySetCell(myQuery, "title", "Title")>
<cfset QueryAddRow(myQuery)>
<cfset QuerySetCell(myQuery, "letter", "B")>
<cfset QuerySetCell(myQuery, "title", "Title")>
<cfset QueryAddRow(myQuery)>
<cfset QuerySetCell(myQuery, "letter", "B")>
<cfset QuerySetCell(myQuery, "title", "Title")>
<cfset QueryAddRow(myQuery)>
<cfset QuerySetCell(myQuery, "letter", "C")>
<cfset QuerySetCell(myQuery, "title", "Title")>
<cfset QueryAddRow(myQuery)>
<cfset QuerySetCell(myQuery, "letter", "C")>
<cfset QuerySetCell(myQuery, "title", "Title")>
...or from the DB. This will allow you to do this:
<ul>
<cfoutput group="letter" query="myQuery">
<li>#myQuery.letter#</li>
<ul>
<cfoutput>
<li>#myQuery.title#</li>
</cfoutput>
</ul>
</cfoutput>
</ul>
On Tue, Aug 25, 2009 at 7:27 AM, Steve LaBadie <[email protected]>wrote:
>
> I want to sort a group of titles alphabetically and separate them into
> Alpha groups.
>
>
>
> A
>
> Title
>
> Title
>
>
>
> B
>
> Title
>
> Title
>
> C....
>
>
>
> I came across ArraySort but not sure if I can specify a single letter of
> the alphabet for my example above. Any guidance would be appreciated.
>
>
>
> A
>
> <cfset ArraySort(aAArray,"textnocase")>
>
> <cfoutput>
>
> <cfloop from="1" to="#ArrayLen(aAArray)#" index="i">
>
> #aAArray[i]#<br/>
>
> </cfloop>
>
> </cfoutput>
>
>
>
> B
>
> <cfset ArraySort(bBArray,"textnocase")>
>
> <cfoutput>
>
> <cfloop from="1" to="#ArrayLen(bBArray)#" index="i">
>
> #bBArray[i]#<br/>
>
> </cfloop>
>
> </cfoutput>
>
>
>
> C....
>
>
>
> Steve LaBadie, Web Manager
>
> East Stroudsburg University
>
> 200 Prospect St.
>
> East Stroudsburg, Pa 18301
>
> 570-422-3999
>
> http://www.esu.edu <http://www.esu.edu>
>
> [email protected] <mailto:[email protected]>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325664
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
