QueryReverse

This function reverses the query data

Method Signature

QueryReverse(query=[query])

Arguments

Argument	Type	Required	Description	Default
query	query	true	The query to reverse

Examples

Reverses a queries results

Run Example

heroes = queryNew( "id,Name", "integer,varchar", [ 
	{
		"id" : 1,
		"Name" : "Bruce Banner"
	},
	{
		"id" : 2,
		"Name" : "Tony Stark"
	},
	{
		"id" : 3,
		"Name" : "Bobby Drake"
	},
	{
		"id" : 4,
		"Name" : "Jean Grey"
	}
] );
writeOutput( "The query:<br />" );
writeDump( heroes );
writeOutput( "The reversed query:<br />" );
writeDump( heroes.reverse() );

Additional Examples

Run Example

testQuery = queryNew( "name , age", "varchar , numeric", { 
	NAME : [
		"Susi",
		"Urs"
	],
	AGE : [
		20,
		24
	]
} );
writeOutput( "The query:<br />" );
writeDump( testQuery );
writeOutput( "The reversed query:<br />" );
writeDump( queryreverse( testQuery ) );

Related

• QueryAddColumn

• QueryAddRow

• QueryAppend

• QueryClear

• QueryColumnArray

• QueryColumnCount

• QueryColumnData

• QueryColumnExists

• QueryColumnList

• QueryCurrentRow

• QueryDeleteColumn

• QueryDeleteRow

• QueryEach

• QueryEvery

• QueryFilter

• QueryGetCell

• QueryGetResult

• QueryInsertAt

• QueryKeyExists

• QueryMap

• QueryNew

• QueryNone

• QueryPrepend

• QueryRecordCount

• QueryRecordCount

• QueryReduce

• QueryRegisterFunction

• QueryRowData

• QueryRowSwap

• QuerySetCell

• QuerySetRow

• QuerySlice

• QuerySome

• QuerySort