Criteria and OR

[Graham Leggett]

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]