Return-Path: <jh@byteaction.de>
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 12233 invoked from network); 13 Feb 2003 09:32:30 -0000
Received: from mail.byteaction.de (212.223.69.193)
  by daedalus.apache.org with SMTP; 13 Feb 2003 09:32:30 -0000
Received: (qmail 14417 invoked from network); 13 Feb 2003 09:32:42 -0000
Received: from unknown (HELO buddyxp) (192.168.0.131)
  by mail.byteaction.de with SMTP; 13 Feb 2003 09:32:42 -0000
From: =?iso-8859-1?Q?J=FCrgen_Hoffmann?= <jh@byteaction.de>
To: <torque-user@db.apache.org>
Subject: Copy criteria object
Date: Thu, 13 Feb 2003 10:32:42 +0100
Organization: ByteAction GmbH
Message-ID: <003a01c2d342$db978dc0$8300a8c0@buddyxp>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook, Build 10.0.4024
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Importance: Normal
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Hi All,

Here is my Problem:

I have a criteria Object that I build like this:

cri.add(cri.getNewCriterion(WebserverDailyPeer.DAY, (Object)
("(UNIX_TIMESTAMP(" + WebserverDailyPeer.DAY + ") between " + (von_date
/ 1000) + " and " + (bis_date / 1000) + " )"), Criteria.CUSTOM));
cri.add(WebserverDailyPeer.KID, kdid);


So when i run the=20
Log.debug(WebserverDailyPeer.createQueryString(cri));
I get:
SELECT  FROM webserver_daily WHERE (UNIX_TIMESTAMP(webserver_daily.DAY)
between 1009839600 and 1041375600 ) AND webserver_daily.KID=3D3

Which is correct. Then I want to use a "copy" of the criteria object and
modify it like this: myCrit =3D cri.clone();
myCrit.addSelectColumn("COUNT(*)");
Log.debug(WebserverDailyPeer.createQueryString(cri));

But then I get:
SELECT COUNT(*) FROM webserver_daily WHERE
webserver_daily.DAY=3D'(UNIX_TIMESTAMP(webserver_daily.DAY) between
1009839600 and 1041375600 )' AND webserver_daily.KID=3D3
^^^^^^^^^^^^^^^^^^^^^

Which is incorrect!!!

Then I tried to just copy the hashtable, but same effect: Criteria
myCrit =3D new Criteria(); Enumeration e =3D cri.keys(); while
(e.hasMoreElements()) {
	Object key =3D e.nextElement();
	myCrit.put(key, cri.get(key));
}

Can someone help me, please?

Mit freundlichen Gr=FCssen
=20
J=FCrgen Hoffmann
ByteACTION GmbH
=20
cert. Perl Programmer
cert. Linux System Administrator
cert. Java Programmer

Besuchen Sie uns doch auf der CeBIT 2003
in Halle 4/Stand 70