I've used this method many times and it works perfectly. I have correct SQL Requests with OR conjunctions and parentesis...
> It works like this : > > Criteria criteria = new Criteria(); > Criteria.Criterion crit1 = > criteria.getNewCriterion(table.id,(Object)null,Criteria.ISNOTNULL); > Criteria.Criterion crit2 = > criteria.getNewCriterion(table1.date1,new Date() > ,Criteria.LESS_THAN); > Criteria.Criterion crit3 = criteria.getNewCriterion(table2.date2,new > Date(),Criteria.GREATER_THAN); > > criteria.add(crit1.or(crit2.and(crit3))); this is what i thought when i read the doc, but i think you have not tried it... you get just AND conjunctions and no parenthesis... :( --------------------------------------------------------------------- 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]
