ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <eloy.garci...@accenture.com>
Subject How to obtain results looking for a NULL
Date Fri, 29 Apr 2005 09:11:53 GMT
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