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
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>

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.