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
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
have.
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

Mime
View raw message