ArrayToList

Description

Converts a one-dimensional array to a list.

Returns

Delimited list, as a string.

Function syntax

ArrayToList(array[, delimiter])

Parameters

Parameter

Description

array

Name of array

delimiter

Character or multicharacter string to separate list elements. The default value is comma.

Example

<h3>ArrayToList Example</h3> 
 
<cfquery name = "GetEmployeeNames" datasource = "cfdocexamples"> 
    SELECT FirstName, LastName FROM Employees 
</cfquery> 
 
<!--- Create an array. ---> 
<cfset myArray = ArrayNew(1)> 
 
<!--- Loop through the query, append names successively to the last element. ---> 
<cfloop query = "GetEmployeeNames"> 
    <cfset temp = ArrayAppend(myArray, "#FirstName# #LastName#")> 
</cfloop> 
 
<!--- Show the resulting array as a list. ---> 
<cfset myList = ArrayToList(myArray, ",")> 
 
<!--- Sort that array in descending order alphabetically. ---> 
<cfset myAlphaArray = ArraySort(myArray, "textnocase", "desc")> 
 
<!--- Show the resulting alphabetized array as a list. ---> 
<cfset myAlphaList = ArrayToList(myArray, ",")> 
 
<!--- Output the array as a list. ---> 
<cfoutput> 
    <p>The contents of the array are as follows: 
    <p>#myList# 
    <p>This array, alphabetized by first name (descending): 
    <p>#myAlphaList# 
    <p>This array has #ArrayLen(MyArray)# elements. 
</cfoutput>