That did the trick !
Thanks,
Prasad
-Original Message-
From: Ron Grabowski [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 10, 2005 12:57 PM
To: ibatis-user-java@incubator.apache.org
Subject: Re: How to escape special characters (specifically '#')
Have you tried using two pound signs?
INSERT INTO ##tempCount
--- Narasimha Prasad <[EMAIL PROTECTED]> wrote:
> Hi
>
>
>
> Is there a way to escape the ‘#’ characters used in iBATIS SQL maps ?
> The
> reason is ask this is that we are running into a situation where we
> need to
> create
>
> Temporary tables to read from, and they use the # character. I tried
> enclosing the statement with , but this works only to
> escape
> special
>
> XML characters.
>
>
>
>
>
> Example:
>
>
> --
>
> BEGIN
>
> CREATE TABLE #tempCount (id INT NOT NULL, count INT)
>
>
>
> INSERT INTO #tempCount
>
> (id, count)
>
> VALUES
>
> (1,2)
>
> SELECT * FROM #tempCount
>
> DROP TABLE #tempCount
>
> END
>
>
>
>
>
> Any suggestions welcome.
>
>
>
> Thanks,
>
> Prasad
--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.1 - Release Date: 3/9/2005
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.1 - Release Date: 3/9/2005