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

Name

ValueList

Synopsis

                  ValueList(queryname.column [,delimiter])

Returns a comma-separated list of values for the previously executed query column specified in queryname.column. 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 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> 
#ValueList(MyQuery.Name)#
</cfoutput>


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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