valueList

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

Argument Reference

column query
Required

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 (,).

Examples

Sample code invoking the valueList function

Simple Example

Retrieve column results

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

Expected Result: 1,2

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

valueList

Argument Reference

column query Required

delimiter string Default: ,

Examples Add An Example Sample code invoking the valueList function

Simple Example

column query
Required

delimiter string
Default: `,`

Examples
Sample code invoking the valueList function