QueryReverse()

reverse the row order of a complete query

Introduced: 6.0.0.18

QueryReverse( query=query );

Returns: Query

Argument Description
query
query, required

query to reverse rows.

Examples

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

See also