db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael.Kashamb...@bmwna.com
Subject RE: Somewhat complex query with Criteria
Date Mon, 31 Jan 2005 13:51:54 GMT
Robert:

You can try this.

Criteria c = new Criteria();

Criteria.Criterion A = criteria.getNewCriterion(NotificationPeer.CODE, 0,
Criteria.EQUAL);

Criteria.Criterion B = criteria.getNewCriterion(NotificationPeer.CODE, 0,
Criteria.NOT_EQUAL);

Criteria.Criterion C = criteria.getNewCriterion(NotificationPeer.TYPE, "C",
Criteria.EQUAL);

criteria.add(A.or(B.and(C)));

Hope this helps.

Michael

-----Original Message-----
From: Robert Bowen [mailto:syg6@yahoo.com]
Sent: Monday, January 31, 2005 4:36 AM
To: torque-user@db.apache.org
Subject: Somewhat complex query with Criteria


I am trying to execute the following query:

SELECT * FROM notification WHERE
( (code=0) OR
(code <>0) AND (type='C') )

I have tried (I think) every possible combination of
Criteria.add, Criteria.and and Criteria.or and I can't
get it to spit out the correct SQL code. It keeps
putting:

WHERE type='C'

at the beginning of the query and then lumping
together the "code" part:

( (code=0) AND (code<>0) )

Anyone have a clue how I can do this? I would prefer
not to use executeQuery() instead ...

Many thanks!
syg


		
__________________________________ 
Do you Yahoo!? 
Take Yahoo! Mail with you! Get it on your mobile phone. 
http://mobile.yahoo.com/maildemo 

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

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


Mime
View raw message