Re: How to obtain results looking for a NULL

[Brice Ruth]

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, [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 Melero

CustomerWorks Europe S.L.

[EMAIL PROTECTED]

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