db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Graham Leggett <minf...@sharp.fm>
Subject Criteria and OR
Date Thu, 01 Apr 2004 12:29:01 GMT
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


Mime
View raw message