Yeah, JDEdwards? :-)
But yes, you just double the character ## or $$
I'm proposing a new syntax for iBATIS 3.x: #{...} and ${...} respectively.
Thoughts and comments welcome.
Clinton
From: Michael Schall [mailto:[EMAIL PROTECTED]
Sent: February-01-08 9:11 AM
To: [email protected]
Subject: Re: how to escape # in the sql statement?
I'm pretty sure you just double the character... I know if you want a $ in
the query, you double it.
http://www.mail-archive.com/[email protected]/msg01897.html
On Feb 1, 2008 9:50 AM, Chen Jin <[EMAIL PROTECTED]> wrote:
Hi All,
I am now in a funny situation. I am using IBatis.NET to connect to a legacy
database system, which there is a column which name contains a "#".
IBatis.NET seems tried to think the # is the started of an in-line
parameter. I use parameter map rather than inline parameter and I even use
quotas to quote the field name but it still does not work (the exception
says "Unrecognized parameter mapping field:."). I check the document there
is no such escape character to escape the "#". Can any one help?
Chen Jin