ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ron Grabowski <rongrabow...@yahoo.com>
Subject Re: How to escape special characters (specifically '#')
Date Thu, 10 Mar 2005 20:57:13 GMT
Have you tried using two pound signs?

 INSERT INTO ##tempCount
 
--- Narasimha Prasad <prasadn@dbo2.com> 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 <![CDATA[ . ]]>, 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

Mime
View raw message