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: How to obtain results looking for a NULL
Date Fri, 29 Apr 2005 13:12:07 GMT
Just change your prepend to an OR when searching for NULL.

<isNull prepend="OR" property="B"> B IS NULL </isNull> 

On 4/29/05, eloy.garcia.b@accenture.com <eloy.garcia.b@accenture.com> wrote:
>  
> Hello; 
>   
> I'm trying to get results from a table, but I can't search for a col = null
> or col = 'value'. 
>   
>   
> This is my sqlmap statement. 
>   
>   
>  
> 
> <statement id="getME" parameterClass="com.MEQuery"
> resultClass="com.MEQuery"> 
> 
> SELECT A, B FROM ME 
> 
> <dynamic prepend="WHERE"> 
> 
> <isNotEmpty prepend="AND" property="A"> A = #A#</isNotEmpty> 
> 
> <isNotEmpty prepend="AND" property="B">B = #B#</isNotEmpty> 
> 
> <isNull prepend="AND" property="B"> B IS NULL </isNull> 
> 
> </dynamic> 
> 
> </statement> 
>   
>   
>   
> Anybody can help me? 
> Thanks. 
>   
>  
> Eloy GarcĂ­a-Borreguero Melero 
> CustomerWorks Europe S.L. 
>  
>  
>  
> eloy.garcia.b@accenture.com 
>  
> Tlf. 944 06 22 00 (Ext. 439) 
>  
> Tlf. 944 04 17 32 
>  
> 
> 
> 
> 
> This message is for the designated recipient only and may contain
> privileged, proprietary, or otherwise private information. If you have
> received it in error, please notify the sender immediately and delete the
> original. Any other use of the email by you is prohibited.

Mime
View raw message