QueryColumnCount

This function returns the number of columns in a query

Method Signature

QueryColumnCount(query=[query])

Arguments

Argument	Type	Required	Description	Default
query	query	true	The query to get the column count from

Examples

Output number of query columns

Run Example

myQuery = queryNew( "ID,name,age" );
writeOutput( queryColumnCount( myQuery ) );

Result: 3

Additional Examples

Run Example

qry = queryNew( "aaa,bbb,ccc,ddd,eee" );
QueryAddRow( qry );
QuerySetCell( qry, "aaa", "sss" );
QueryAddRow( qry, 3 );
QuerySetCell( qry, "aaa", (1) );
QueryAddRow( qry, 1 );
writeDump( queryColumnCount( qry ) );

Related

• QueryAddColumn

• QueryAddRow

• QueryAppend

• QueryClear

• QueryColumnArray

• QueryColumnData

• QueryColumnExists

• QueryColumnList

• QueryCurrentRow

• QueryDeleteColumn

• QueryDeleteRow

• QueryEach

• QueryEvery

• QueryFilter

• QueryGetCell

• QueryGetResult

• QueryInsertAt

• QueryKeyExists

• QueryMap

• QueryNew

• QueryNone

• QueryPrepend

• QueryRecordCount

• QueryRecordCount

• QueryReduce

• QueryRegisterFunction

• QueryReverse

• QueryRowData

• QueryRowSwap

• QuerySetCell

• QuerySetRow

• QuerySlice

• QuerySome

• QuerySort