Hi,
What you can do is to override the method ignoreCaseInOrderBy(String) in
your DB adapter (most probably DBDB2400.java). If you do not know why it
does not work you can just return the argument. Note that if you do this,
all orderBy's will be case sensitive.
Alternatively, you can try to fix its behaviour.
I am afraid there is no way to turn case insensitive ordering off in a
criteria. Look at SQLBuilder.processOrderBy() to see yourself.
If you found out what the problem is and how to fix it, can you please open
up an issue in scarab on the problem ?
Thomas
"Husek, Paul" <[EMAIL PROTECTED]> schrieb am 06.12.2005 00:21:14:
> I'm using torque with the as400 driver. Most the time it works great.
> Lately though I've notice when I do a
>
>
>
> addAscendingOrderBy() to a criteria I get a sql error:
>
>
>
> [SQL0171] Argument 1 of function UCASE not valid
>
>
>
> I'm looking for a quick workaround for this. I'm not sure I can wait
> for a torque patch Can I add a custom order by where it won't cause
> this ucase function to be called?
>
>
>
> Thanks!
>
>
>
> Paul
>
>
>
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
