Re: Issue with special character

> 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@...]
> Gesendet: Donnerstag, 25. Juni 2009 13:06
> An: user-java@...
> 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@...> 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
>
>
>