db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <fisc...@seitenbau.net>
Subject Antwort: Set ignoreCase in Criteria
Date Tue, 16 Jan 2007 16:38:01 GMT
You can set ignorecase also for the Criterion objects in the criteria
(Basically, for every column where you create a condition a criterion
object is created inside the criteria object). Create the criteria without
ignoreCase, retrieve the criterions where you want to ignore case and use
setIgnoreCase(true) on these criterions.


"Frauke Heyl" <fheyl@vps.de> schrieb am 16.01.2007 16:57:20:

> Hello,
> I am using Torque 3.3-RC1 together with MSSQL Server and I ran into
> the following problem:
> If I call Criteria.setIgnoreCase(true);
> all columns and values are wrapped with UPPER, no matter wich type they
> So for a datetime field I get some statement like:
> select * from TABLE_X where UPPER(X_DATE) = UPPER('20070116 00:00:00')
> which does not return the expected result set.
> Do you have any solution for this problem?
> Thank you and
> best regards
> Frauke Heyl

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

View raw message