ibatis-user-cs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chen Jin" <c...@helpathome.com>
Subject RE: how to escape # in the sql statement?
Date Fri, 01 Feb 2008 19:47:21 GMT
I tried ## and ####, neither works. However, I think that is great we can
have a new syntax to avoid that. Thanks!


Chen Jin


From: Clinton Begin [mailto:clinton.begin@gmail.com] 
Sent: Friday, February 01, 2008 11:32 AM
To: user-cs@ibatis.apache.org
Subject: RE: how to escape # in the sql statement?


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.







From: Michael Schall [mailto:mike.schall@gmail.com] 
Sent: February-01-08 9:11 AM
To: user-cs@ibatis.apache.org
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.


On Feb 1, 2008 9:50 AM, Chen Jin <cjin@helpathome.com> 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



View raw message