CFML Reference

QuotedValueList

Description

Gets the values of each record returned from an executed query. ColdFusion does not evaluate the arguments.

Return value

A delimited list of the values of each record returned from an executed query. Each value is enclosed in single quotation marks.

Category

Query functions

Syntax

QuotedValueList(query.column [, delimiter ]) 

See also

ValueList

Parameters

Parameter	Description
query.column	Name of an executed query and column. Separate query name and column name with a period.
delimiter	A string or a variable that contains one. Character(s) that separate column data.

Example

<h3>QuotedValueList Example</h3>
<!--- use the contents of one query to create another dynamically --->
<cfset List = "'BIOL', 'CHEM'">
<!--- first, get the department IDs in our list --->
<cfquery name = "GetDepartments" datasource = "cfsnippets">
  SELECT Dept_ID FROM Departments
  WHERE Dept_ID IN (#PreserveSingleQuotes(List)#)
</cfquery>
<!--- now, select the courses for that department based on the
quotedValueList produced from our previous query --->
<cfquery name = "GetCourseList" datasource = "cfsnippets">
  SELECT *
  FROM CourseList
  WHERE Dept_ID IN (#QuotedValueList(GetDepartments.Dept_ID)#)
</cfquery>
<!--- now, output the results --->
<cfoutput QUERY = "GetCourseList" >
<pre>#Course_ID#  #Dept_ID#  #CorNumber#  #CorName#</pre>
</cfoutput>

Copyright © 2002, Macromedia Inc. All rights reserved.

Comments