ValueList()
Returns a list of all the values, for a given column within the query, delimited by the value given.
It is recommended to use QueryColumnData() instead.
Status:
ValueList( query_column=queryColumn, delimiter=string );
Returns: String
| Argument | Description | Default |
|---|---|---|
|
query_column
queryColumn,
required
|
edit
Name of an executed query and column. Separate query name and column name with a period. Alias: queryColumn |
|
|
delimiter
string,
optional
|
edit
A delimiter character to separate column data items. Default: comma (,). Alias: delimiters |
, |
Examples
edittest_query = queryNew("name , age" , "varchar , numeric", { name: [ "John Doe" , "Jane Doe", "Frank Jones" ] , age: [ 20 , 24, 33 ] });
dump(ValueList(test_query.name, "; "));
See also
- Queries
- QueryColumnData()
- Search Issue Tracker open_in_new
- Search Lucee Test Cases open_in_new (good for further, detailed examples)