| 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 syntaxQuotedValueList(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 | |
| DELIMITER | |