ValueList

"-->

 ValueList (query.column [, delimiter]) 

Description

Inserts a delimiter between each value in an executed query. ColdFusion does not evaluate the arguments.

Example

 <cfquery name = "exampleQuery1" datasource = "test">  SELECT testID FROM Example  WHERE testID IN ('XZY')  </cfquery>  <cfquery name = " exampleQuery1" datasource = "test">  SELECT *  FROM Test  WHERE testID IN ('#ValueList(exampleQuery1.testID)#')  </cfquery>