criteria.add(Peer.quantity1, (Object) (Peer.quantity1 + " < " + Peer.quantity2), Criteria.CUSTOM);
G.
On Monday, October 28, 2002, at 03:56 pm, 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- [EMAIL PROTECTED]> For additional commands, e-mail: <mailto:turbine-torque-user- [EMAIL PROTECTED]>
Development Team Leader, eGS, 5-7 Singer Street, London EC2A 4BQ. +44 (0)20 7336 1440
CONFIDENTIALITY: This is email is confidential and intended solely for the use of the individual to whom it is addressed.� Any views or opinions presented are solely those of the author and do not necessarily represent those of eGovernment Solutions (UK) Ltd.� If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, or copying of this email is strictly prohibited.� If you have received this email in error please contact the sender.
--
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>
