DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=12806>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=12806 doDelete() does not work properly if adding criterions to criteria Summary: doDelete() does not work properly if adding criterions to criteria Product: Turbine Version: 3.0 Platform: PC OS/Version: Linux Status: NEW Severity: Critical Priority: Other Component: Torque AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] I'm using Torque "torque-020302.tar.gz" with postgres on linux. I want to delete a range of rows: Criteria c=new Criteria(); c.add(MyclassPeer.S1, "s1"); c.add(MyclassPeer.S2, "s2"); Criteria.Criterion cc1=c.getNewCriteria(MyclassPeer.ID, new Integer(2), Criteria.GREATER_EQUAL); Criteria.Criterion cc2=c.getNewCriteria(MyclassPeer.ID, new Integer(5), Criteria.LESS_THAN); cc1.and(cc2); c.add(cc1); // the where clause would be: WHERE S1="s1" AND S2="s2" AND ID>=2 AND ID<5 MyclassPeer.doDelete(criteria); However the result is that all rows, which match the first two conditions and whose id>=2, are deleted. Looking at postgres traces I found out that the where clause omits cc2, i.e. WHERE S1="s1" AND S2="s2" AND ID>=2 I'd appreciate for any helps/workaround! Thx -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
