• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Name

QuotedValueList

Synopsis

                  QuotedValueList(queryname.column [,delimiter])

Returns a comma-separated list of values for the previously executed query column specified in queryname.column. Each element in the list is qualified with a single quote character. An optional delimiter can be specified if the list is to be delimited with a character other than the comma (the default). The following example creates a quoted value list from a ColdFusion query:

<cfquery name="MyQuery" datasource="ProgrammingCF">
  SELECT * FROM EmployeeDirectory
</cfquery>
   
<cfoutput>
<b>The query column Name contains the following values:</b> 
#QuotedValueList(MyQuery.Name)#
</cfoutput>


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint