J�rgen, the new address is [EMAIL PROTECTED]
> -----Urspr�ngliche Nachricht----- > Von: J�rgen Hoffmann [mailto:[EMAIL PROTECTED]] > Gesendet: Donnerstag, 13. Februar 2003 09:02 > An: [EMAIL PROTECTED] > Betreff: Copy criteria object > > > Hi All, > > I am sending this question to this list, because I am receiving > MAILER-DAEMONS when following the subscription links to the torque-user > mailinglists from the torque website. > > 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 > 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=3 > > Which is correct. Then I want to use a "copy" of the criteria object and > modify it like this: > myCrit = cri.clone(); > myCrit.addSelectColumn("COUNT(*)"); > Log.debug(WebserverDailyPeer.createQueryString(cri)); > > But then I get: > SELECT COUNT(*) FROM webserver_daily WHERE > webserver_daily.DAY='(UNIX_TIMESTAMP(webserver_daily.DAY) between > 1009839600 and 1041375600 )' AND webserver_daily.KID=3 > ^^^^^^^^^^^^^^^^^^^^^ > > Which is incorrect!!! > > Then I tried to just copy the hashtable, but same effect: > Criteria myCrit = new Criteria(); > Enumeration e = cri.keys(); > while (e.hasMoreElements()) > { > Object key = e.nextElement(); > myCrit.put(key, cri.get(key)); > } > > Can someone help me, please? > > Mit freundlichen Gr�ssen > > J�rgen Hoffmann > ByteACTION GmbH > > cert. Perl Programmer > cert. Linux System Administrator > cert. Java Programmer > > Besuchen Sie uns doch auf der CeBIT 2003 > in Halle 4/Stand 70 > > > --------------------------------------------------------------------- > 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]
