Return-Path: Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: (qmail 278 invoked from network); 28 Jan 2010 01:42:19 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 28 Jan 2010 01:42:19 -0000 Received: (qmail 26448 invoked by uid 500); 28 Jan 2010 01:42:19 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 26408 invoked by uid 500); 28 Jan 2010 01:42:18 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 26398 invoked by uid 99); 28 Jan 2010 01:42:18 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 28 Jan 2010 01:42:18 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [219.88.242.56] (HELO mx6.orcon.net.nz) (219.88.242.56) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 28 Jan 2010 01:42:09 +0000 Received: from Debian-exim by mx6.orcon.net.nz with local (Exim 4.69) (envelope-from ) id 1NaJOE-0000z1-Su for user@cayenne.apache.org; Thu, 28 Jan 2010 14:41:46 +1300 Received: from [60.234.9.102] (helo=[192.168.250.12]) by mx6.orcon.net.nz with esmtpsa (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.69) (envelope-from ) id 1NaJOE-0000yp-MR for user@cayenne.apache.org; Thu, 28 Jan 2010 14:41:46 +1300 From: Andrew Lindesay Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Subject: Using an Escaped LIKE Clause Date: Thu, 28 Jan 2010 14:41:46 +1300 Message-Id: <975F892E-BDF0-40D1-9458-A3E653172EF5@lindesay.co.nz> To: user@cayenne.apache.org Mime-Version: 1.0 (Apple Message framework v1077) X-Mailer: Apple Mail (2.1077) X-DSPAM-Check: by mx6.orcon.net.nz on Thu, 28 Jan 2010 14:41:46 +1300 X-DSPAM-Result: Whitelisted X-DSPAM-Processed: Thu Jan 28 14:41:46 2010 X-DSPAM-Confidence: 0.6091 X-DSPAM-Probability: 0.0000 Hello; A question about escaping a LIKE qualifier; ExpressionFactory.likeExp(...,...) JDBC specifies the ability to use '%' and '_' as matchers for characters = and a character respectively. It is then possible to escape use of = those characters as in the following example; SELECT a FROM tabA WHERE a LIKE '%=3D_' {escape '=3D'} I can't easily see a means by which one can specify the "escape" clause = in a SelectQuery -- can anybody shed some light on this for me. Regards; ___ Andrew Lindesay www.lindesay.co.nz