Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 21069 invoked from network); 20 Dec 2003 12:06:09 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 20 Dec 2003 12:06:09 -0000 Received: (qmail 70005 invoked by uid 500); 20 Dec 2003 12:06:05 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 69991 invoked by uid 500); 20 Dec 2003 12:06:05 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 69978 invoked from network); 20 Dec 2003 12:06:05 -0000 Received: from unknown (HELO mail.gft.com) (213.68.142.133) by daedalus.apache.org with SMTP; 20 Dec 2003 12:06:05 -0000 Received: from Ramah ([172.24.1.3]) by mail.gft.com with Microsoft SMTPSVC(5.0.2195.6713); Sat, 20 Dec 2003 13:06:03 +0100 From: "Ramah" To: "Apache Torque Users List" Subject: RE: Using Upper and Lower functions in Criteria Date: Sat, 20 Dec 2003 17:35:50 +0530 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 In-Reply-To: <3FE3AE2C.4080301@backstagetech.com.au> Importance: Normal X-OriginalArrivalTime: 20 Dec 2003 12:06:04.0006 (UTC) FILETIME=[A428C860:01C3C6F1] X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N 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:seade@backstagetech.com.au] 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: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org