QueryColumnData

Returns the data in a query column.

Method Signature

QueryColumnData(query=[query], columnName=[string])

Arguments

Argument	Type	Required	Description	Default
query	query	true	The query to get the column data from.
columnName	string	true	The name of the column to get the data from.

Examples

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

Run Example

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

Using a member function

Run Example

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

Additional Examples

Run Example

myQuery = QueryNew( "" );
names = [
	"xxxx",
	"yyyy"
];
queryAddColumn( myQuery, "name", "varchar", names );
result = queryColumnData( myQuery, "name" );
writeDump( result );

Related

• QueryRecordCount

• QueryColumnList

• QueryRowSwap

• QuerySort

• QueryEach

• QueryKeyExists

• QueryColumnCount

• QueryReduce

• QueryCurrentRow

• QueryRowData

• QueryFilter

• QueryAddRow

• QueryNew

• QueryReverse

• QueryPrepend

• QueryColumnExists

• QueryAddColumn

• QueryGetCell

• QueryGetResult

• QueryMap

• QueryEvery

• QueryRecordCount

• QuerySome

• QueryDeleteColumn

• QuerySetCell

• QueryInsertAt

• QueryClear

• QuerySetRow

• QueryColumnArray

• QueryDeleteRow

• QueryAppend

• QuerySlice

• QueryRegisterFunction