August 2003
Intermediate to advanced
1140 pages
68h 45m
English
QuotedValueList
QuotedValueList(queryname.column [,delimiter])Returns a comma-separated list of values for the previously executed
query column specified in
queryname.column. Each element in the list
is qualified with a single quote character. An optional delimiter can
be specified if the list is to be delimited with a character other
than the comma (the default). The following example creates a quoted
value list from a ColdFusion query:
<cfquery name="MyQuery" datasource="ProgrammingCF"> SELECT * FROM EmployeeDirectory </cfquery> <cfoutput> <b>The query column Name contains the following values:</b> #QuotedValueList(MyQuery.Name)# </cfoutput>