You are viewing a plain text version of this content. The canonical link for it is here.

Posted to torque-user@db.apache.org by Alex Laudani - Softmasters <al...@softmasters.net> on 2007/10/15 03:07:28 UTC

complex query with torque

Hello,
how can I do the following query using torque?

Select * FROM (tableA) where ((column1)*24+(column2))>(myvariable) ?

thank you
Regards.

Antwort: complex query with torque

Posted by Thomas Fischer <fi...@seitenbau.net>.

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

softmasters@gmail.com 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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org