Re: order by col1, col2 nulls first ??

[T E Schmitz]

assuming COL2 is numeric:
ORDER BY COL1, coalesce (COL2,0)

which translates to

criteria.addAscendingOrderByColumn(COL1);
criteria.addAscendingOrderByColumn("coalesce (COL2,0)");

I can't remember whether I had to patch Torque to accept the above 
character string.

"Garret O'Kelly" <[EMAIL PROTECTED]> schrieb am 20.01.2006 13:30:26:
What I want is
... order by col1, col2 asc nulls first


I've tried
criteria.addAscendingOrderByColumn(MyPeer.COL1);
criteria.addAscendingOrderByColumn("col2 nulls first");

but this gives:
... order by col1 asc, col2 nulls first asc
which is invalid for Oracle

I've also tried
criteria.addAscendingOrderByColumn(MyPeer.COL1);
criteria.getOrderByColumns.add("col2 nulls first asc");

but that also gives an exception

I'm using torque 3.0 btw

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]