You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user-java@ibatis.apache.org by Narasimha Prasad <pr...@dbo2.com> on 2005/03/10 21:03:25 UTC

How to escape special characters (specifically '#')

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

 

 


-- 
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