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.
Thomas
"Frauke Heyl" <[EMAIL PROTECTED]> 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
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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
