cfdocs

queryColumnData

Returns the data in a query column. See also valueArray for use in ACF.

queryColumnData(query, columnName [, closure])

returns array

Member Function Syntax

query.columnData(columnName [, closure])

Argument Reference

Name	Type	Required	Default	Description
query	query	Yes
columnName	string	Yes
closure	function	No

Create and populate a query and output the ‘name’ column data as an array

myQuery = QueryNew( '' );
names = [ 'Indra','Elizabeth','Harry','Seth' ];
queryAddColumn( myQuery,'name','varchar',names );
result = queryColumnData( myQuery,'name' );
Dump( var='#result#' );

Using a member function

myQuery = QueryNew( '' );
names = [ 'Indra','Elizabeth','Harry','Seth' ];
queryAddColumn( myQuery,'name','varchar',names );
result = myQuery.columnData( 'name' );
Dump( var='#result#' );

This site is open source. Improve this page.