Return-Path: Delivered-To: apmail-incubator-ibatis-user-java-archive@www.apache.org Received: (qmail 14111 invoked from network); 29 Apr 2005 10:25:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 29 Apr 2005 10:25:56 -0000 Received: (qmail 90056 invoked by uid 500); 29 Apr 2005 10:27:08 -0000 Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org Received: (qmail 90040 invoked by uid 500); 29 Apr 2005 10:27:07 -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 Delivered-To: moderator for ibatis-user-java@incubator.apache.org Received: (qmail 30851 invoked by uid 99); 29 Apr 2005 09:09:03 -0000 X-ASF-Spam-Status: No, hits=0.2 required=10.0 tests=HTML_MESSAGE,NO_REAL_NAME X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of eloy.garcia.b@accenture.com designates 170.252.72.95 as permitted sender) Content-Transfer-Encoding: 7bit X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.3790.181 Importance: normal Priority: normal Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C54C9A.E14F6AD9" Subject: How to obtain results looking for a NULL Date: Fri, 29 Apr 2005 11:11:53 +0200 Message-ID: <070247EEED211E4DB03F9649E02456060134B3BF@EMEXM1102.dir.svc.accenture.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: How to obtain results looking for a NULL thread-index: AcVMm3vR08b0NprzQDSbqlwokm+Cng== From: To: X-OriginalArrivalTime: 29 Apr 2005 09:07:34.0527 (UTC) FILETIME=[E1B3F8F0:01C54C9A] X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. ------_=_NextPart_001_01C54C9A.E14F6AD9 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello; =20 I'm trying to get results from a table, but I can't search for a col =3D = null or col =3D 'value'. =20 =20 This is my sqlmap statement. =20 =20 SELECT A, B FROM ME A =3D #A# B =3D #B# B IS NULL =20 =20 =20 =20 Anybody can help me? Thanks. =20 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 = 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. ------_=_NextPart_001_01C54C9A.E14F6AD9 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Mensaje
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"com.MEQuery">

SELECT A, B = FROM=20 ME

<dynamic prepend=3D"WHERE">

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

<isNotEmpty prepend=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
CustomerWorks Europe S.L.
eloy.garcia.b@accenture.com
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.

------_=_NextPart_001_01C54C9A.E14F6AD9--