Tags · Functions · Objects
Lucee Function Reference
Choose a function:

Function QUERYSORT

Sorts the query based on the column specified and the order criteria given. Modifies the original query object

Example

querysort(query query,string column_name,[string direction]):boolean

Arguments

The arguments for this function are set. You can not use other arguments except the following ones.
Name Type Required Default Value Description
query query  Yes   the query to sort  
column_name string  Yes   a list of names or a single column name  
direction string  No a list of directions or a single direction defintion (asc,desc), the list must have the same length as the columnName list