db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andre Steinmetzger" <Andre.Steinmetz...@cimt-ag.de>
Subject AW: convert/cast sql expression
Date Wed, 26 Mar 2008 10:27:32 GMT
Hallo Thomas,
this is exactly what I need. Thanks. Works fine.


Von: Thomas Fischer [mailto:fischer@seitenbau.net]
Gesendet: Di 25.3.2008 18:10
An: Apache Torque Users List
Betreff: RE: convert/cast sql expression

Seems like Criteria.CUSTOM is what you need. See


section "Using the CUSTOM modifier to use custom SQL"

   Hope this helps,


"Andre Steinmetzger" <Andre.Steinmetzger@cimt-ag.de> schrieb am 25.03.2008

> Hallo I`m using torque 3.2 and search for a methode to create a convert
> cast expression in the final sql. The target database is DB2. I hope
> 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

View raw message