ibatis-user-cs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Schall" <mike.sch...@gmail.com>
Subject Re: how to escape # in the sql statement?
Date Fri, 01 Feb 2008 22:28:39 GMT
Can you post your actual sqlmap xml so we can see what you are trying to do?

On 2/1/08, Chen Jin <cjin@helpathome.com> wrote:
>
> 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.
>
>
>
> Clinton
>
>
>
>
>
>
>
>
>
> *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.
>
> http://www.mail-archive.com/user-cs@ibatis.apache.org/msg01897.html
>
> 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
>
>
>
>
>

Mime
View raw message