db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <fisc...@seitenbau.net>
Subject RE: convert/cast sql expression
Date Tue, 25 Mar 2008 17:10:28 GMT

Seems like Criteria.CUSTOM is what you need. See

http://db.apache.org/torque/releases/torque-3.3
/runtime/reference/read-from-db.html

section "Using the CUSTOM modifier to use custom SQL"

   Hope this helps,

        Thomas

"Andre Steinmetzger" <Andre.Steinmetzger@cimt-ag.de> schrieb am 25.03.2008
17:07:44:

> Hallo I`m using torque 3.2 and search for a methode to create a convert
or
> cast expression in the final sql. The target database is DB2. I hope
somebody
> can help me.
>
> e.g. The column plz is a character datatyp and I like to use something
like that:
>
>         select * from dim.region where integer(dim.region.plz) between
10000 and 12000
>
> Thanks. Andre


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message