| CFML Reference |
|
|
ColdFusion Functions |
|
| CFML Reference |
|
|
ColdFusion Functions |
|
Returns a comma-separated list of the values of each record returned from a previously executed query.
ValueList(query.column [, delimiter ])
| Parameter |
Description |
|---|---|
| query.column |
Name of an executed query and column. Separate query name and column name with a period. |
| delimiter |
A string delimiter to separate column data. |
<!--- 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>
| Copyright © 2001, Macromedia Inc. All rights reserved. |
|