db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Frauke Heyl" <fh...@vps.de>
Subject Set ignoreCase in Criteria
Date Tue, 16 Jan 2007 15:57:20 GMT
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

View raw message