ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <Markus.K...@bafin.de>
Subject AW: Issue with special character
Date Thu, 25 Jun 2009 13:16:26 GMT
Jeff,

Great, this works.

Thanks !!

Markus
 

-----Urspr√ľngliche Nachricht-----
Von: Jeff Butler [mailto:jeffgbutler@gmail.com] 
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 <Markus.Kopp@bafin.de> wrote:
> Thanks for the hint, but
>  select * from ZAHLINST.AGENTEN where <![CDATA[ID#]]> = #id# does not 
> work
>
> I get the following exception:
> Caused by: com.ibatis.sqlmap.client.SqlMapException: Incorrect inline 
> parameter map format (missmatched name=value pairs):  =
>
> 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 
> it will help...
>
>
>
>
> On Thu, Jun 25, 2009 at 2:56 PM, <Markus.Kopp@bafin.de> 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# = #myId#
>
> 	does not work.
>
> 	Also the resultMap mapping
> 	  <resultMap id="TableResult" class="Table">
> 	    <result property="id" column="ID#" />
> 	   ...
> 	  </resultMap>
>
>
> 	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


Mime
View raw message