Can you post your actual sqlmap xml so we can see what you are trying to do?
On 2/1/08, Chen Jin <[EMAIL PROTECTED]> 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:[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 > > > > >

