db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Huang" <danih...@cisco.com>
Subject RE: Criteria and OR
Date Thu, 01 Apr 2004 18:24:11 GMT
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:minfrin@sharp.fm]
Sent: Thursday, April 01, 2004 4:29 AM
To: torque-dev@db.apache.org
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: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message