Return-Path: 
 <user-java-return-3316-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 88442 invoked from network); 15 Jul 2005 15:32:29 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 15 Jul 2005 15:32:29 -0000
Received: (qmail 14255 invoked by uid 500); 15 Jul 2005 15:32:26 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 14231 invoked by uid 500); 15 Jul 2005 15:32:25 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 14218 invoked by uid 99); 15 Jul 2005 15:32:25 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 15 Jul 2005 08:32:25 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [192.18.98.36] (HELO brmea-mail-4.sun.com) (192.18.98.36)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 15 Jul 2005 08:32:21 -0700
Received: from esunmail ([129.147.156.34])
	by brmea-mail-4.sun.com (8.12.10/8.12.9) with ESMTP id j6FFWMr3013014
	for <user-java@ibatis.apache.org>; Fri, 15 Jul 2005 09:32:23 -0600 (MDT)
Received: from xpa-fe1 (esunmail [129.147.156.34]) by
 edgemail1.Central.Sun.COM
 (iPlanet Messaging Server 5.2 HotFix 2.02 (built Oct 21 2004))
 with ESMTP id <0IJO00J7JDTYUN@edgemail1.Central.Sun.COM> for
 user-java@ibatis.apache.org; Fri, 15 Jul 2005 09:32:22 -0600 (MDT)
Received: from [129.147.48.45] by mail.sun.net
 (iPlanet Messaging Server 5.2 HotFix 2.02 (built Oct 21 2004))
 with ESMTPSA id <0IJO002MUDTY8Q@mail.sun.net> for
 user-java@ibatis.apache.org;
 Fri, 15 Jul 2005 09:32:22 -0600 (MDT)
Date: Fri, 15 Jul 2005 09:32:22 -0600
From: Nathan Maves <Nathan.Maves@Sun.COM>
Subject: check if one of two fields are null
To: user-java@ibatis.apache.org
Message-id: <0DEBB118-CD20-4193-8585-E5844E38EF16@sun.com>
MIME-version: 1.0
X-Mailer: Apple Mail (2.733)
Content-type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Content-transfer-encoding: 7BIT
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

I need to have a dynamic query that appends a where clause if one of  
two fields are null.

I could only come up with

<isNull property="field1">
         DO THIS
</isNull>

<isNull property="field2">
         DO THIS
</isNull>

This is obviously wrong since the code could be appended twice.

I need to combine these two statement so that DO THIS is only  
executed if one of the fields (field1,field2) are null.

Nathan