When I tried,
criteria.getCriterion(YourPeerPeer.ENAME).setIgnoreCase(true);
The following exception occurs.
java.lang.NullPointerException
at org.apache.torque.util.BasePeer.createQuery(BasePeer.java:1066)
at org.apache.torque.util.BasePeer.createQueryString(BasePeer.java:927)
...
Thanks and Regards,
Ramah
-----Original Message-----
From: Scott Eade [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 20, 2003 7:34 AM
To: Apache Torque Users List
Subject: Re: Using Upper and Lower functions in Criteria
Ramah wrote:
> Is there any possibility to use UPPER and LOWER function of SQL in
> Criteria?
>
> *Ex: Select eid from employee where upper(ename)='XYZ'.
> How to create Criteria for the above Query?*
>
try:
criteria.getCriterion(YourPeerPeer.ENAME).setIgnoreCase(true);
Scott
--
Scott Eade
Backstage Technologies Pty. Ltd.
http://www.backstagetech.com.au
---------------------------------------------------------------------
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]
