|
QuotedValueList
DescriptionGets
the values of each record returned from an executed query. ColdFusion
does not evaluate the arguments.
ReturnsA delimited
list of the values of each record returned from an executed query. Each
value is enclosed in single-quotation marks.
Function syntaxQuotedValueList(query.column [, delimiter ])
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>
|