I want to do the following SQL in Oracle using Criteria:
select * from foo where trunc(foo.bar) <= sysdate
I don't know how to add a function in Torque around the column name. If
I use:
Criteria c = new Criteria();
c.add("trunc("+FOO.BAR+")", new Date, LESS_EQUAL)
or
c.add(FOO.TABLE_NAME, "trunc(" + FOO.BAR + ")", new Date, LESS_EQUAL)
Torque will confuse table name and columns name in both cases. Any other
solutions?
Thanks,
Howard Lin
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
