Re: AW: Why SQL statement is not terminated correctly?

2003-10-03 Thread fumi
Hi Vitali, Thanx(Arigatou) for your reply. Sorry for my slow reply & my poor english. "Usselmann, Vitali" <[EMAIL PROTECTED]> wrote: > I can not tell you the difference between your code fragments. > I solved my problems with Criteria.or() by using the Criterion > object instead of Criteria.or()

Trouble building Torque

2003-10-03 Thread Melissa A Klein
When I try to build torque (leaving torque in the jar), I get the following: Buildfile: {workspace}\torque-gen-3.1\build-torque.xml main: check-use-classpath: check-run-only-on-schema-change: sql-check: sql: [echo] +--+ [echo] |

RE: COUNT(*) in Torque

2003-10-03 Thread Jerry Brenner
I'm not using Torque, just monitoring the mailing list in case we move in that direction. The DISTINCT in your query is unnecessary (and will probably be removed by the optimizer anyway). The GROUP BY makes the DISTINCT redundant. -Original Message- From: Michael Kashambuzi [mailto:[

COUNT(*) in Torque

2003-10-03 Thread Michael Kashambuzi
Hi: I was wondering how one can do the following in Torque. I have a table people which has rows where the lastname can be repeated multiple times. I'm trying to do SELECT DISTINCT LASTNAME, COUNT(*) FROM PEOPLE GROUP BY LASTNAME ORDER BY LASTNAME ASC I've generated all the Torque classes for