Re: Using Upper and Lower functions in Criteria

[Scott Eade]

Please post the code that builds the criteria that resulted in the NPE.

Scott

--
Scott Eade
Backstage Technologies Pty. Ltd.
http://www.backstagetech.com.au
Ramah wrote:

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
 





---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]