Many thanks
 
Al Pivonka

(H)317.295.1737

Those who say it can't be done,
are usually interrupted by those doing it.


----- Original Message ----
From: Jeff Butler <[EMAIL PROTECTED]>
To: [email protected]; al pivonka <[EMAIL PROTECTED]>
Sent: Wednesday, August 23, 2006 9:36:09 AM
Subject: Re: Unsubscribe?

I've just added unsibscribe info to the mailing lists page here:
 

Jeff Butler



 

On 8/23/06, al pivonka <[EMAIL PROTECTED]> wrote:
How does one unsubscribe from this list, I don't have time right now to read all of this.
 
Al Pivonka

(H)317.295.1737

Those who say it can't be done,
are usually interrupted by those doing it.


----- Original Message ----
From: Chema < [EMAIL PROTECTED]>
To: [email protected]
Sent: Wednesday, August 23, 2006 7:41:59 AM
Subject: Distinguish null and not null parameters

Hello:

I like to compose the next query

<select id="idQuery" parameterClass="com.project.ParameterClass" resultClass=" java.lang.String">
    SELECT ID FROM  TABLE
    WHERE
    <isNotNull property="field1">
        AND FIELD1 = #field1#
    </isNotNull>
    <isNull property="field1">
        AND FIELD1 IS NULL
    </isNull>
</select>

Is there another better way to distinguish null and not null parameters ?

With only one parameter is not problem like in the previous example  , but really I need to make a comparision with many fields of ParameterClass ( All parameters not named like fieldX )

Thanks a lot

Best regards


 

 


Reply via email to