CFML Reference Previous Up One Level Next Search
ColdFusion Functions


ListChangeDelims

Description

Returns list with delimiter characters changed to new_delimiter string.

Category

List functions

Syntax 

ListChangeDelims(list, new_delimiter [, delimiters ])

See also

ListFirst, ListQualify

Parameters

Parameter
Description
list
 List of delimiters to change
new_delimiter
 String to use as a new delimiter
delimiters
 Set of delimiters used in list

Example 

<!--- This example shows ListChangeDelims --->
<html>
<head>
<title>ListChangeDelims Example</title>
</head>

<body>
<H3>ListChangeDelims Example</H3>

<P>ListChangeDelims lets you change the delimiters used in a list.
<!--- First, query to get some values for our list --->
<cfquery name = "GetParkInfo" datasource = "cfsnippets">
SELECT   PARKNAME,CITY,STATE
FROM  PARKS
WHERE  PARKNAME LIKE 'BA%'
</cfquery>
<cfset temp = #ValueList(GetParkInfo.ParkName)#>
<cfoutput>
<P>The original list: #temp#
</cfoutput>
<!--- now, change the delimiters in the list from "," to
"|:P|"--->
<cfset temp2 = ListChangeDelims(Temp, "|:P|", ",")>
<cfoutput>
<P>The appended list: #temp2#
</cfoutput>

</body>
</html>
Copyright © 2001, Macromedia Inc. All rights reserved. Previous Up Next Search