Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 82841 invoked from network); 20 Dec 2003 02:04:57 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 20 Dec 2003 02:04:57 -0000 Received: (qmail 17976 invoked by uid 500); 20 Dec 2003 02:04:38 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 17866 invoked by uid 500); 20 Dec 2003 02:04:38 -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 17850 invoked from network); 20 Dec 2003 02:04:37 -0000 Received: from unknown (HELO mail.iinet.net.au) (203.59.3.34) by daedalus.apache.org with SMTP; 20 Dec 2003 02:04:37 -0000 Received: (qmail 14660 invoked from network); 20 Dec 2003 02:04:36 -0000 Received: from unknown (HELO backstagetech.com.au) (203.217.17.173) by mail.iinet.net.au with SMTP; 20 Dec 2003 02:04:36 -0000 Message-ID: <3FE3AE2C.4080301@backstagetech.com.au> Date: Sat, 20 Dec 2003 13:04:28 +1100 From: Scott Eade User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031007 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Apache Torque Users List Subject: Re: Using Upper and Lower functions in Criteria References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 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