Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 62197 invoked from network); 31 Mar 2005 09:03:07 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 31 Mar 2005 09:03:07 -0000 Received: (qmail 66467 invoked by uid 500); 31 Mar 2005 09:03:05 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 66449 invoked by uid 500); 31 Mar 2005 09:03: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 66434 invoked by uid 99); 31 Mar 2005 09:03:05 -0000 X-ASF-Spam-Status: No, hits=0.4 required=10.0 tests=DNS_FROM_RFC_ABUSE X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from web42005.mail.yahoo.com (HELO web42005.mail.yahoo.com) (66.218.93.173) by apache.org (qpsmtpd/0.28) with SMTP; Thu, 31 Mar 2005 01:03:03 -0800 Received: (qmail 613 invoked by uid 60001); 31 Mar 2005 09:03:01 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=D+vPgwnRtieKUE6wfAnBvqr94cOYPurxWUflYkv8pT6Y3wSzHVspS8hZo/QbXtmJCuFGIXCBnqmZsw7A3AgLyyZpvik03I7so9nof3h4URTePHXlm1L+MaQep6e/bgFRqgiaAE4y6L2T7Q/TRGvixwsl10DuqMMYcF9GQDadj1A= ; Message-ID: <20050331090300.611.qmail@web42005.mail.yahoo.com> Received: from [217.14.40.1] by web42005.mail.yahoo.com via HTTP; Thu, 31 Mar 2005 01:03:00 PST Date: Thu, 31 Mar 2005 01:03:00 -0800 (PST) From: Robert Bowen Subject: RE: Criteria.setIgnoreCase() and boolean fields? To: Apache Torque Users List In-Reply-To: 6667 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N I *am* using BOOLEANCHAR, and it still doesn't work. I'll have to take a look at scarab, don't know what it is! syg --- Thomas Fischer wrote: > > > > > Sounds like a bug to me. Can you please enter this > in scarab, including the > database and the torque version you use ? > > As a workaround, you can try to change your > datamodel such that you use the > data type booleanchar instead of boolean. > > Thomas > > Robert Bowen schrieb am 31.03.2005 > 10:02:13: > > > Hello all. I have a class that sets a whole bunch > of > > conditions for a search. Most of the fields I > search > > on are text so using Criteria.setIgnoreCase() has > been > > working. > > > > I recently added another search criteria, on a > boolean > > field: > > > > criteria.add(NotificationPeer.IS_COMPLETE, false); > > > > But since the setIgnoreCase() is set to true for > the > > Criteria, Torque tries to do an UPPER() on a > boolean > > field! > > > > Can I avoid this somehow? Currently it crashes in > a > > rather ugly way ... > > > > Thanks! > > syg > > > > > > > > __________________________________ > > Do you Yahoo!? > > Make Yahoo! your home page > > http://www.yahoo.com/r/hs > > > > > --------------------------------------------------------------------- > > 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 > > __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org