what do you think about a 'NOT'-flag in the criteria ?
Criteri crit = new Criteria();
crit.addEqualTo("field1","test1"); crit.addEqualTo("field2","test1"); crit.setNegative(true);
result:
select ... from ... where NOT (field1='test1' and field2='test2')
jakob
Robert Coup wrote:
Hi all,
I find the PB Query interface nice to use, and we're wrapping it on the UI side of our application to allow users to do some simple querying. Then I ran into a small problem - there is no addNotCriteria! :)
Since you need AND, OR, and NOT to make any boolean expression it seems a bit strange that it isn't in there...
and while you can do: A.a=1 and A.b!=1 and A.c!=1 you can't 'not' a whole sub-criteria: A.a=1 and NOT (A.b=1 or A.c=1)
Was there any particular reason that it was left out, or any easy work-around bearing in mind the query structure could be a lot more complex than my example?
OTOH, where would I look to add it? From my brief glance around Criteria I would need to add another Type, but the code to go from Criteria to SQL i didn't find...
Thanks,
Rob :)
--------------------------------------------------------------------- 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]