Name
QuotedValueList
Synopsis
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>Get Programming ColdFusion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
