Thomas, Thanks tons for the quick response. Your recommendation for a fix worked! As time permits I'll see if I can determine why it was failing and contribute to the project through a patch.
Paul -----Original Message----- From: Thomas Fischer [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 06, 2005 4:24 AM To: Apache Torque Users List Subject: RE: as400 ordering problem 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
