Adobe ColdFusion 8

QuotedValueList

Description

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

Returns

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, List functions

Function 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

<!--- 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 = "cfdocexamples">
    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 = "cfdocexamples">
    SELECT *
    FROM CourseList
    WHERE Dept_ID IN ('#GetDepartments.Dept_ID#')
</cfquery>

<!--- now, output the results --->

List the course numbers that are in BIOL and CHEM (uses semicolon (;) as the delimiter):<br>
<cfoutput>
#QuotedValueList(GetCourseList.CorNumber,";")#<br> 
</cfoutput>