You're probably adding criteria instead of making Criterions and or-ing
them first. The following code fragment works and will probably do what
you need.
Regards,
David.
------
Criteria c = new Criteria();
Criteria.Criterion x = c.getNewCriterion(ItemPeer.ITEMID, new
Integer(4), Criteria.EQUAL);
Criteria.Criterion y = c.getNewCriterion(ItemPeer.STAGEID, new
Integer(10), Criteria.EQUAL);
c.add(x.or(y));
On Thu, 2004-04-01 at 13:29, Graham Leggett wrote:
> 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]
