Name
ValueList
Synopsis
ValueList(queryname.column
[,delimiter
])
Returns a comma-separated list of values for the previously executed
query column specified in queryname.column
. 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 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> #ValueList(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.