Thank you for your reply. but this code also deletes all the records that are greater than d1 and does not consider d2 at all. The strange part is the same criteria works very well for doSelect but not for doDelete. So it looks like the implementation of doDelete is doing something wrong.
Anyway, right now as a work-around, I'm just doing a doSelect using the criteria and then I loop through the list and delete each record using its primary key. Thanx, Kalyani -----Original Message----- From: guy galil [mailto:[EMAIL PROTECTED] Sent: Monday, June 06, 2005 10:26 AM To: Apache Torque Users List Subject: Re: Problem with doDelete The way to use the same column twice in one statement is as follows: Criteria c = new Criteria(); c.add(Time.EDATE, d1, Criteria.GREATER_EQUAL); Criteria.Criterion criterion = c.getCriterion(Time.EDATE); criterion.and( c.getNewCriterion( criterion.getTable(), criterion.getColumn(), d2, Criteria.LESS_EQUAL ) ); Time.doDelete(c, conn); --- Kalyani Kale <[EMAIL PROTECTED]> wrote: > Hi, > > I have a problem with doDelete of torque. This is a > sample piece of my > code. > > > > conn = Transaction.beginOptional( "db", true ); > > > > DateFormat df = new SimpleDateFormat("MM/dd/yyyy"); > > Date d1 = df.parse("05/15/2005"); > > Date d2 = df.parse("05/21/2005"); > > > > Criteria c = new Criteria(); > > c.add(Time.LOGINID, getLoginID()); > > > c.add(Time.EDATE, d1, Criteria.GREATER_EQUAL); > > c.add(Time.EDATE, d2, Criteria.LESS_EQUAL); > > > > Time.doDelete(c, conn); > > > > Transaction.commit( conn ); > > > > Now, ideally this should delete the records of Time > table having EDate > between 15th May 2005 and 22nd May 2005. > > But it does not consider date d2 at all and deletes > all the records that > are greater than d1. > > > > What could be the problem? > > > > Thanx, > > Kalyani > > > > --------------------------------------------------------------------- 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]
