http://livedocs.adobe.com/ Macromedia LiveDocs - online documentation with user feedback. Copyright 2009, Macromedia, Inc. 2009-11-25T03:03:37 en-us http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functa59.htm#13511 Editing the example as follows better illustrates what the QuotedValueList function does:<br /><br /><!--- use the contents of one query to create another dynamically ---><br /><cfset List = "'BIOL', 'CHEM'"><br /><!--- first, get the department IDs in our list ---><br /><cfquery name = "GetDepartments" datasource = "cfsnippets"><br /> SELECT Dept_ID FROM Departments<br /> WHERE Dept_ID IN (#PreserveSingleQuotes(List)#)<br /></cfquery><br /><!--- now, select the courses for that department based on the<br />quotedValueList produced from our previous query ---><br /><cfquery name = "GetCourseList" datasource = "cfsnippets"><br /> SELECT *<br /> FROM CourseList<br /> WHERE Dept_ID IN ('#GetDepartments.Dept_ID#')<br /></cfquery><br /><!--- now, output the results ---><br /><br />List the course numbers that are in BIOL and CHEM (uses semicolon (;) as the delimiter:<br><br /><cfoutput><br /> #QuotedValueList(GetCourseList.CorNumber,";")#<br> <br /></cfoutput> tzimmerman 0 0 2004-04-28T07:37:45