# ValueList

Returns a comma-separated list of the values of each record returned from a previously executed query.

See also QuotedValueList.

### Syntax

    ValueList(query.column [, delimiter ])

##### query.column

Name of an already executed query and column. Separate query name and column name with a period ( . ).

##### delimiter

A string delimiter to separate column data.

### Example

    <!--- This example shows the use of ValueList --->
    <HTML>
    <HEAD>
    <TITLE>ValueList Example</TITLE>
    </HEAD>

    <BODY>
    <H3>ValueList Example</H3>

    <!--- use the contents of one 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>

    </BODY>
    </HTML>