ValueList |
Description
Inserts a delimiter between each value in an executed query. ColdFusion does not evaluate the arguments.
Returns
A delimited list of the values of each record returned from an executed query.
Category
Other functions, Query functions
Function syntax
    ValueList(query.column [, delimiter ])
See also
QuotedValueList
Parameters
Parameter | Description
query.column | Name of an executed query and column. Separate query name and column
| name with a period.
delimiter | A delimiter character to separate column data items. Default: comma (,).
Example
    <h3>ValueList Example</h3>

    <!--- use the contents of a query to create another dynamically --->
    <cfquery name = "GetDepartments" datasource = "cfsnippets">
       SELECT Dept_ID FROM Departments
       WHERE Dept_ID IN (`BIOL')
    </cfquery>

    <cfquery name = "GetCourseList" datasource = "cfsnippets">
    SELECT *
       FROM CourseList
       WHERE Dept_ID IN (`#ValueList(GetDepartments.Dept_ID)#')
    </cfquery>

    <cfoutput QUERY = "GetCourseList" >
    <pre>#Course_ID#   #Dept_ID#   #CorNumber#   #CorName#</pre>
    </cfoutput>

query.column |
Name of an executed query and column. Separate query name and column name with a period.

delimiter |
A delimiter character to separate column data items. Default: comma (,).