August 2001
Intermediate to advanced
976 pages
38h 8m
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>Read now
Unlock full access