Return-Path: Delivered-To: apmail-incubator-ibatis-user-java-archive@www.apache.org Received: (qmail 59386 invoked from network); 29 Apr 2005 13:13:23 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 29 Apr 2005 13:13:23 -0000 Received: (qmail 88221 invoked by uid 500); 29 Apr 2005 13:14:22 -0000 Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org Received: (qmail 88172 invoked by uid 500); 29 Apr 2005 13:14:22 -0000 Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm Precedence: bulk Reply-To: ibatis-user-java@incubator.apache.org List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list ibatis-user-java@incubator.apache.org Received: (qmail 88144 invoked by uid 99); 29 Apr 2005 13:14:21 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE,RCVD_BY_IP X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of bdruth@gmail.com designates 64.233.184.194 as permitted sender) Received: from wproxy.gmail.com (HELO wproxy.gmail.com) (64.233.184.194) by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 29 Apr 2005 06:14:21 -0700 Received: by wproxy.gmail.com with SMTP id 69so817272wra for ; Fri, 29 Apr 2005 06:13:00 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:references; b=U9Wt0KNGnO3e738qIqPa1fZmre7GHz8FNlOxTRNCuT0P8xldeySfuRftT9p8BTLsdCr56ZQ5I0fq6tHDQ+vptp5n1LFV+NuA7/6XBVNAuCX7m3HskSx6cPUVUOGL8+aVYQbxDIJiO+wLsz5LTgzbaJb6ClVKtRclFbAyl6NnWNY= Received: by 10.54.26.2 with SMTP id 2mr1692204wrz; Fri, 29 Apr 2005 06:13:00 -0700 (PDT) Received: by 10.54.40.18 with HTTP; Fri, 29 Apr 2005 06:13:00 -0700 (PDT) Message-ID: Date: Fri, 29 Apr 2005 08:13:00 -0500 From: Brice Ruth Reply-To: Brice Ruth To: ibatis-user-java@incubator.apache.org Subject: Re: How to obtain results looking for a NULL In-Reply-To: <070247EEED211E4DB03F9649E02456060134B3BF@EMEXM1102.dir.svc.accenture.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_251_29098557.1114780380779" References: <070247EEED211E4DB03F9649E02456060134B3BF@EMEXM1102.dir.svc.accenture.com> X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------=_Part_251_29098557.1114780380779 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Does it work when you use straight JDBC, with the parameterClass that you'r= e=20 passing in being used to populate your prepared statement? On 4/29/05, eloy.garcia.b@accenture.com wrote= : >=20 > Hello; > I'm trying to get results from a table, but I can't search for a col =3D= =20 > null or col =3D 'value'. > This is my sqlmap statement. > =20 > MEQuery"> >=20 > SELECT A, B FROM ME >=20 > >=20 > A =3D #A# >=20 > B =3D #B# >=20 > B IS NULL =20 >=20 > >=20 > > Anybody can help me? > Thanks. > *Eloy Garc=EDa-Borreguero Melero* > CustomerWorks Europe S.L. > eloy.garcia.b@accenture.com > Tlf. 944 06 22 00 (Ext. 439) > Tlf. 944 04 17 32 > =20 > This message is for the designated recipient only and may contain=20 > privileged, proprietary, or otherwise private information. If you have=20 > received it in error, please notify the sender immediately and delete the= =20 > original. Any other use of the email by you is prohibited. >=20 --=20 Brice Ruth Software Engineer, Madison WI ------=_Part_251_29098557.1114780380779 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Does it work when you use straight JDBC, with the parameterClass that you'r= e passing in being used to populate your prepared statement?

On 4/29/05, eloy.garcia.b@accenture.com <eloy.garcia.b@accenture.com> wrote:

Hello;

I'm trying to get=20 results from a table, but I can't search for a col =3D null or col =3D=20 'value'.

This is my sqlmap=20 statement.

<statement id= =3D"getME" parameterClass =3D"com.MEQuery" resultClass=3D&qu= ot;com.MEQuery">=

SELECT A, <= span>B FROM=20 ME

<dynamic prepend=3D"WHERE">

<isNotEmpty prepend<= /font>=3D"AND" property =3D"A"> A=20 =3D #A#</isNotEmpty>

<isNotEmpty prepend<= /font>=3D"AND" property =3D"B">B =3D #B#</isNotEmpty= >

<isNull prepend=3D"AND" property =3D"B"> B IS NULL=20 </isNull>

</dynamic>=

</statement>

Anybody can help=20 me?

Thanks.

Eloy Garc=EDa= -Borreguero=20 Melero

Custom= erWorks Europe S.L.

eloy.garcia= .b@accenture.com

Tlf. 944 06 22 00 (Ext. 439)<= /div>

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, Madi= son WI ------=_Part_251_29098557.1114780380779--