User Guide
554 CFML Language Reference
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>