QueryColumnData()
Returns all the data in a query for a given column
QueryColumnData( query=query, columnName=string, closure=function );
Returns: Array
| Argument | Description |
|---|---|
|
query
query,
required
|
edit
query object do get data from |
|
columnName
string,
required
|
edit
name of the column returned |
|
closure
function,
optional
|
edit
UDF/Closure that call with the values from column Alias: function, callback, udf |
Examples
editmyQuery = QueryNew( '' );
names = [ 'xxxx','yyyy'];
queryAddColumn( myQuery,'name','varchar',names );
result = queryColumnData( myQuery,'name' );
writeDump(result);
See also
- Queries
- ValueArray()
- ValueList()
- query.columnData()
- Search Issue Tracker open_in_new
- Search Lucee Test Cases open_in_new (good for further, detailed examples)