<!--- This example shows ListSort--->
<HTML>
<HEAD>
<TITLE>ListSort Example</TITLE>
</HEAD>

<BASEFONT FACE="Arial, Helvetica" SIZE=2>
<BODY  bgcolor="#FFFFD5">

<BASEFONT FACE="Arial, Helvetica" SIZE=2>
<BODY  bgcolor="#FFFFD5">
<H3>ListSort Example</H3>

<!--- Find a list of users who wrote messages --->
<CFQUERY NAME="GetMessageUser" DATASOURCE="cfsnippets">
SELECT	Username, Subject, Posted
FROM    Messages
</CFQUERY>

<CFSET myList = ValueList(GetMessageUser.UserName)>
<P>Here is the unsorted list. </P>

<CFOUTPUT>
#myList#
</CFOUTPUT>
<P>Here is the list sorted alphabetically:</P>
<CFSET sortedList = ListSort(myList, "Text")>
<CFOUTPUT>
#sortedList#
</CFOUTPUT>

<P>Here is a numeric list that is to be sorted in descending order.</P>
<CFSET sortedNums = ListSort("12,23,107,19,1,65","Numeric", "Desc")>
<CFOUTPUT>
#sortedNums#
</CFOUTPUT>

<P>Here is a list that must be sorted numerically, since it contains both negative and positive numbers, as well as decimal numbers. </P>

<CFSET sortedNums2 = ListSort("23.75;-34,471:100,-9745","Numeric", "ASC", ";,:")>

<CFOUTPUT>
#sortedNums2#
</CFOUTPUT>

<P>Here is a list that is to be sorted alphabetically without consideration of case.</P>

<CFSET sortedMix = ListSort("hello;123,HELLO,hello:jeans,-345,887;ColdFusion:coldfusion", "TextNoCase", "ASC", ";,:")>

<CFOUTPUT>
#sortedMix#
</CFOUTPUT>

</BODY>
</HTML>       


