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 );

Last updated

Was this helpful?