Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 61817 invoked from network); 14 Nov 2003 18:44:44 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 14 Nov 2003 18:44:44 -0000 Received: (qmail 32209 invoked by uid 500); 14 Nov 2003 18:44:31 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 32189 invoked by uid 500); 14 Nov 2003 18:44:31 -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 32005 invoked from network); 14 Nov 2003 18:44:29 -0000 Received: from unknown (HELO solar.servlets.net) (209.162.192.251) by daedalus.apache.org with SMTP; 14 Nov 2003 18:44:29 -0000 Received: from fastasdell.localhost.localdomain (pcp02470760pcs.union01.nj.comcast.net [68.37.101.90]) by solar.servlets.net (8.12.8/8.12.8) with ESMTP id hAEIiTQr002062 for ; Fri, 14 Nov 2003 10:44:29 -0800 Subject: Re: Why? Criteria.LIKE From: Dave Newton To: Apache Torque Users List In-Reply-To: <20031125104309.D5BA.106@suzuki.email.ne.jp> References: <20031125104309.D5BA.106@suzuki.email.ne.jp> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8-3mdk Date: 14 Nov 2003 13:40:39 -0500 Message-Id: <1068835240.2080.17.camel@fastasdell.localhost.localdomain> Mime-Version: 1.0 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 On Mon, 2003-11-24 at 21:09, Toru Suzuki wrote: > String note = "\*comment"; > Criteria cri = new Criteria(); > cri.add(PERSON.NOTE, (Object)(note + "%"), Criteria.LIKE); > > SQL log is > SELECT PERSON.NAME, PERSON.NOTE FROM PERSON > WHERE PERSON.NOTE LIKE '\comment%' > > I expected > WHERE PERSON.NOTE LIKE '*comment%' Did this get answered? Is it just a java string issue (need to backslash a backslash)? Dave --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org