Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 13533 invoked from network); 25 Jun 2009 13:16:47 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 25 Jun 2009 13:16:47 -0000 Received: (qmail 92857 invoked by uid 500); 25 Jun 2009 13:16:57 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 92818 invoked by uid 500); 25 Jun 2009 13:16:57 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 92810 invoked by uid 99); 25 Jun 2009 13:16:57 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 25 Jun 2009 13:16:57 +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 [195.126.85.150] (HELO pxmail1.secunet.ivbv.net) (195.126.85.150) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 25 Jun 2009 13:16:49 +0000 Received: from pxmf1.secunet.ivbv.net (pxmf1 [192.168.12.1]) by pxmail1.secunet.ivbv.net (BVN-AZI Mail-Service) with ESMTP id 8B066390E13 for ; Thu, 25 Jun 2009 13:16:08 +0000 (UTC) Received: from pxmail1.secunet.ivbv.net (pxmail1.secunet.ivbv.net [192.168.11.1]) by pxmf1-in.secunet.ivbv.net (BVN-AZI Mail-Service) with ESMTP id B6D7113407D for ; Thu, 25 Jun 2009 15:16:27 +0200 (CEST) Received: from TrustMail (unknown [10.247.68.3]) by pxmail1.secunet.ivbv.net (BVN-AZI Mail-Service) with SMTP id 5D472390E13 for ; Thu, 25 Jun 2009 13:16:08 +0000 (UTC) Received: from babwex02.office.dir ([172.26.0.142]) by TrustMail (Totemo SMTP Server) with SMTP ID 221 for ; Thu, 25 Jun 2009 15:16:27 +0200 (CEST) Received: from BVMX01.servers.office.dir (172.26.1.120) by BABWEX02.office.dir (172.26.0.142) with Microsoft SMTP Server id 8.1.375.2; Thu, 25 Jun 2009 15:16:27 +0200 Received: from BVMX02.servers.office.dir ([172.26.1.130]) by BVMX01.servers.office.dir with Microsoft SMTPSVC(6.0.3790.3959); Thu, 25 Jun 2009 15:16:27 +0200 Received: from BAFEXCH01.office.dir ([172.20.0.150]) by BVMX02.servers.office.dir with Microsoft SMTPSVC(6.0.3790.3959); Thu, 25 Jun 2009 15:16:27 +0200 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-MimeOLE: Produced By Microsoft Exchange V6.5 Subject: AW: Issue with special character Date: Thu, 25 Jun 2009 15:16:26 +0200 Message-ID: <770A60020ACCBE49A017074DF131B4240719CD25@BAFEXCH01.office.dir> In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Issue with special character Thread-Index: Acn1ldP9Vi2VNRQvQ5yZD3hvYg4YswAARkiA References: <770A60020ACCBE49A017074DF131B4240719CD23@BAFEXCH01.office.dir> <536e8800906250406g591c4c45i842bbd7663f6d166@mail.gmail.com> <770A60020ACCBE49A017074DF131B4240719CD24@BAFEXCH01.office.dir> From: To: X-OriginalArrivalTime: 25 Jun 2009 13:16:27.0202 (UTC) FILETIME=[2555DA20:01C9F597] X-Virus-Checked: Checked by ClamAV on apache.org Jeff, Great, this works. Thanks !! Markus =20 -----Urspr=FCngliche Nachricht----- Von: Jeff Butler [mailto:jeffgbutler@gmail.com]=20 Gesendet: Donnerstag, 25. Juni 2009 15:00 An: user-java@ibatis.apache.org Betreff: Re: Issue with special character Escape the column name by doubling the hash mark: Select id## from ... Jeff Butler On 6/25/09, Markus.Kopp@bafin.de wrote: > Thanks for the hint, but > select * from ZAHLINST.AGENTEN where =3D #id# does = not=20 > work > > I get the following exception: > Caused by: com.ibatis.sqlmap.client.SqlMapException: Incorrect inline=20 > parameter map format (missmatched name=3Dvalue pairs): =3D > > Markus > > ________________________________ > > Von: Nicholoz Koka Kiknadze [mailto:kiknadze@gmail.com] > Gesendet: Donnerstag, 25. Juni 2009 13:06 > An: user-java@ibatis.apache.org > Betreff: Re: Issue with special character > > > Have you tried enclosing field names containing # with CDATA ? Maybe=20 > it will help... > > > > > On Thu, Jun 25, 2009 at 2:56 PM, wrote: > > > Hi, > > in our DB2 database, some columns have a # in their name, e.g. > ID# > This conflicts now with the iBatis placeholder character #, e.g. > > > select * from table where ID# =3D #myId# > > does not work. > > Also the resultMap mapping > > > ... > > > > Does not work. > > Does anybody know, how to escape # in iBatis? > > Thanks a lot > Markus > > > -- Sent from my mobile device --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org For additional commands, e-mail: user-java-help@ibatis.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org For additional commands, e-mail: user-java-help@ibatis.apache.org