August 2003
Intermediate to advanced
1140 pages
68h 45m
English
ValueList
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>