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]
