-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 [...] > > 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
apparently, Criteria does not implement clone(). if it cheers you up, you're not alone: http://www.mail-archive.com/turbine-torque-user@jakarta.apache.org/msg01480.html (probably you find something useful for you in this thread) i ended up working around this problem by creating a specific query for Counts, either with Criteria (it should work if you just use the Criteria one time), or with the village objects themself. rick - -- |- | peter riegersperger <[EMAIL PROTECTED]> |- | ein windows switcher tagebuch: | http://forum.subnet.at/viewforum.php?f=22 |- | subnet | platform for media art and experimental technologies |- | http://www.subnet.at/ |- | muehlbacherhofweg 5 // 5020 salzburg // austria |- | fon/fax +43/662/842 897 |- -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+S3X4IMP39JYOy9IRAh6YAKDYqPN9i23ZLVRWMi2WjJ93JQDfMgCfT9Ea sj1QPXpekJEMzf2anbyMO9U= =YFuR -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]