On 4/29/05,
[EMAIL PROTECTED] <[EMAIL PROTECTED]> 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 MeleroCustomerWorks Europe S.L.Tlf. 944 06 22 00 (Ext. 439)Tlf. 944 04 17 32This 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