Returns each value from a column of an executed query.
CFML does not evaluate the arguments.
A delimited list of the values of each record returned from an
executed query column

valueList(column [, delimiter]) → returns String

valueList Argument Reference

column QueryColumn

Name of an executed query and column. Separate query name
and column name with a period.

delimiter String
Default: ,

A delimiter character to separate column data items.
Default: comma (,).
  • ,
  • |
  • ;
  • chr(9)
  • chr(10)
  • chr(13)

Examples sample code invoking the valueList function

Simple Example

Retrieve column results

news = queryNew("id,title",
    [ {"id":1,"title":"Dewey defeats Truman"}, {"id":2,"title":"Man walks on Moon"} ]);
writeOutput( valueList( );

Expected Result: 1,2

Fork me on GitHub