User Guide
732 Chapter 3: ColdFusion Functions
<cfset myArray = ArrayNew(1)>
<!--- loop through query; append these names successively
to the last element --->
<cfloop query = "GetEmployeeNames">
<cfset temp = ArrayAppend(myArray, "#FirstName# #LastName#")>
</cfloop>
<!--- sort that array descending alphabetically --->
<cfset myAlphaArray = ArraySort(myArray, "textnocase")>
<!--- show the resulting array as a list --->
<cfset myList = ArrayToList(myArray, ",")>
<cfoutput>
<p>The contents of the unqualified list are as follows:</p>
#myList#
</cfoutput>
<!--- show the resulting alphabetized array as a qualified list with
single quotation marks around each full name. --->
<cfset qualifiedList1 = ListQualify(myList,"'",",","CHAR")>
<!--- output the array as a list --->
<cfoutput>
<p>The contents of the qualified list are as follows:</p>
<p>#qualifiedList1#</p>
</cfoutput>
<!--- show the resulting alphabetized array as a qualified list with quotation
marks around each full name. We use " to denote quotation marks
because the quotation mark character is a control character. --->
<cfset qualifiedList2 = ListQualify(myList,""",",","CHAR")>
<!--- output the array as a list --->
<cfoutput>
<p>The contents of the second qualified list are:</p>
<p>#qualifiedList2#</p>
</cfoutput>