ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brandon Goodin <brandon.goo...@gmail.com>
Subject Re: turning off prepending the 'N' character.
Date Sat, 18 Jun 2005 00:16:15 GMT
what version are you using? We haven't seent his behavior anywhere
else in our unit tests or from users.

Brandon

On 6/17/05, Narasimha Prasad <prasadn@dbo2.com> wrote:
>  
>  
> 
> 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