ValueList

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

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>

CFML Language Reference
Chapter 2 : ColdFusion Functions