Jeff, Great, this works.
Thanks !! Markus -----Ursprüngliche Nachricht----- Von: Jeff Butler [mailto:jeffgbut...@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.k...@bafin.de <markus.k...@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:kikna...@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.k...@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-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
