Hi, I'd use Criteria.CUSTOM for that. See the section "Using the CUSTOM modifier to use custom SQL" in
http://db.apache.org/torque/releases/torque-3.3 /runtime/reference/read-from-db.html Thomas [EMAIL PROTECTED] schrieb am 15.10.2007 03:07:28: > Hello, > how can I do the following query using torque? > > Select * FROM (tableA) where ((column1)*24+(column2))>(myvariable) ? > > thank you > Regards. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]