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:[EMAIL PROTECTED] Sent: Friday, February 01, 2008 11:32 AM To: [email protected] 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:[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
