ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brice Ruth <bdr...@gmail.com>
Subject Re: How to obtain results looking for a NULL
Date Fri, 29 Apr 2005 13:13:00 GMT
Does it work when you use straight JDBC, with the parameterClass that you're 
passing in being used to populate your prepared statement?

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



-- 
Brice Ruth
Software Engineer, Madison WI

Mime
View raw message