Try criteria.add(PolicyNoteReversalPeer.REVERSAL_ID, a); Criteria.Criterion critOrigId = criteria.getNewCriterion(PolicyNoteReversalPeer.ORIGINAL_ID, a); criteria.or(critOrigId);
Regards, Daniel -----Original Message----- From: Graham Leggett [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 4:29 AM To: [EMAIL PROTECTED] Subject: Criteria and OR Hi all, I have a criteria that is to generate a SQL statement "where x=a or y=a" like so: criteria.or(PolicyNoteReversalPeer.REVERSAL_ID, a); criteria.or(PolicyNoteReversalPeer.ORIGINAL_ID, a); This criteria generates the following sql: SELECT FROM policy_note_reversal WHERE policy_note_reversal.REVERSAL_ID=29156 AND policy_note_reversal.ORIGINAL_ID=29156 Does anyone know why an OR would be rendered as an AND? I am using torque v3.1. Regards, Graham -- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
