Your question's been answered already on the list, but just as a point
of reference, *IN GENRAL*, mailing lists provide a header in every
mail about various administrative functions.  Headers in these ibatis
mails include:

List-Help: <mailto:[EMAIL PROTECTED]>
List-Unsubscribe: <mailto:[EMAIL PROTECTED]>
List-Post: <mailto:[email protected]>


Now I know that in this world of "make it easy for the user", your
mail client won't always provide an easy or well known way of LOOKING
at headers that aren't date, subject, to, and from, but if you have
the means, that's often a good place to start.



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






--
[Taglines] are like I Ching or Tarot. They don't mean anything,
but sometimes if you think about them you'll get a useful idea.
--Ron Jeffries (?)

Reply via email to