ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Narasimha Prasad" <pras...@dbo2.com>
Subject turning off prepending the 'N' character.
Date Fri, 17 Jun 2005 23:01:09 GMT
Hi 

 

I observed that when queries are constructed by ibatis, it prepends a
character ā€˜Nā€™ to the parameters.   Is there a way to turn this off ?

 

Eg: (Say regionCodeList contains two regions, East and West)

 

      <isNotEmpty prepend="AND" property="regionCodeList">

        Project.regionCode IN

        <iterate open="(" property="regionCodeList" conjunction=","
close=")">

          #regionCodeList[]#

        </iterate>                

      </isNotEmpty>

 

translates to

 

AND Project.regionCode IN  ( N'REGION_EAST', N'REGION_WEST'  )

      

 

 

Thanks,

Prasad

 

DBO2 Inc

650-587-0106

 


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.7.8/22 - Release Date: 6/17/2005
 

Mime
View raw message