Function syntax
ListToArray(list [, delimiters[, includeEmptyFields[, multiCharacterDelimiter]]])
Usage
ColdFusion,
by default, ignores empty list elements; thus, the list "a,b,c,,,d"
has four elements.
ColdFusion treats each character in the delimiters parameter
as a separate delimiter. Therefore, if the parameter is ",+" ColdFusion
will break the list at either a comma or a plus sign.
If
you specify a multiCharacterDelimiter parameter,
all list elements must be separated by exactly the specified characters.
For example, the following code creates an array with three entries,
“red, orange”, “yellow, green” and “blue, violet”.
<cfset list = "red,orange,&yellow,green,&blue,violet">
<cfset arr = listToArray (list, ",&",false,true)>
Example
<h3>ListToArray Example</h3>
<!--- Find a list of users who wrote messages --->
<cfquery name = "GetMessageUser" datasource = "cfdocexamples">
SELECT Username, Subject, Posted
FROMMessages
</cfquery>
<cfset myList = ValueList(GetMessageUser.UserName)>
<p>My list is a list with <cfoutput>#ListLen(myList)#</cfoutput>
elements.
<cfset myArrayList = ListToArray(myList)>
<p>My array list is an array with <cfoutput>#ArrayLen(myArrayList)#
</cfoutput> elements.