Try the following: Critiera criteria = new Criteria(); criteria.add(Peer.quantity1,(Object)(PEER.quantity1 + " < " + PEER.quantity2),Criteria.CUSTOM);
----- Rafal Daniel Craigen wrote:
I have a problem using the criteria class.
I want to compare two columns from one table like so
SELECT * from table where quantity1 < quantity2
where quantity1 and quantity2 are column names.
If i do
Critiera criteria = new Criteria();
criteria.add(Peer.quantity1,(Object)Peer.quantity2,Criteria.LESS_THAN);
i get the quantity2 column enclosed with quotes?
I may be being entirely stupid in not being able to sort this but could
someone please pull the wool from my eyes?
Using TDK 2.1 with MySql 4.01.
-- To unsubscribe, e-mail: <mailto:turbine-torque-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:turbine-torque-user-help@;jakarta.apache.org>
