home *** CD-ROM | disk | FTP | other *** search
- <!--- 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>
-
-
-