Example 6 with Column
use of lucee.runtime.sql.exp.Column in project Lucee by lucee.
the class QoQ method order.
private static void order(Query qry, Column[] columns) throws PageException {
Column col;
for (int i = columns.length - 1; i >= 0; i--) {
col = columns[i];
qry.sort(col.getColumn(), col.isDirectionBackward() ? Query.ORDER_DESC : Query.ORDER_ASC);
}
}
Also used :
QueryColumn(lucee.runtime.type.QueryColumn)
Column(lucee.runtime.sql.exp.Column)
Aggregations
Column (lucee.runtime.sql.exp.Column)6
Expression (lucee.runtime.sql.exp.Expression)4
ColumnExpression (lucee.runtime.sql.exp.ColumnExpression)3
QueryColumn (lucee.runtime.type.QueryColumn)2
ParserString (lucee.commons.lang.ParserString)1
RefBoolean (lucee.commons.lang.types.RefBoolean)1
RefBooleanImpl (lucee.commons.lang.types.RefBooleanImpl)1
DatabaseException (lucee.runtime.exp.DatabaseException)1
Select (lucee.runtime.sql.Select)1
Operation (lucee.runtime.sql.exp.op.Operation)1
ValueNumber (lucee.runtime.sql.exp.value.ValueNumber)1
ValueString (lucee.runtime.sql.exp.value.ValueString)1
Collection (lucee.runtime.type.Collection)1
Key (lucee.runtime.type.Collection.Key)1
QueryImpl (lucee.runtime.type.QueryImpl)1
