Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ibatis-user-java@incubator.apache.org
Received-SPF: pass (hermes.apache.org: domain of brandon.goodin@gmail.com
 designates 64.233.170.194 as permitted sender)
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:content-transfer-encoding:content-disposition:references;
        b=ccQtu6lVa8MVSZbpflDU9Zq+/neA3aV5CUAACmLPt+qGMJ1cA3zETtjkmimOrxjbKjzuEA5Ls1BDsTx/S4QFPg4rYnCcCllath6CJwzY70yUL7AjQVzil7I/4UCu3GwOR60cTlKk8TTWmnKAA4XYjQ+u/sCGdNddIMOmmsj9nZQ=
Message-ID: <2fe5ef5b050506133354e4245c@mail.gmail.com>
Date: Fri, 6 May 2005 14:33:58 -0600
From: Brandon Goodin <brandon.goodin@gmail.com>
Reply-To: Brandon Goodin <brandon.goodin@gmail.com>
To: ibatis-user-java@incubator.apache.org
Subject: Re: How to obtain results looking for a NULL
In-Reply-To: 
 <070247EEED211E4DB03F9649E02456060134BCE2@EMEXM1102.dir.svc.accenture.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: 
 <070247EEED211E4DB03F9649E02456060134BCE2@EMEXM1102.dir.svc.accenture.com>

Then i'm not completely sure what you are asking for. Write out your
SQL statement in it's most complex form without tags. Just write
straight SQL. If you do that i think i'll understand what you are
wanting.

Brandon

On 5/5/05, eloy.garcia.b@accenture.com <eloy.garcia.b@accenture.com> wrote:
> =20
> To Brandon Goodin=20
>  =20
> The prepend=3D"OR" doesn't works; and I don't want the next:=20
> Example: A=3D'2' B=3Dnull=20
> SELECT A, B FROM ME =20
>     WHERE A=3D'2'=20
>             OR B IS NULL=20
> I want AND, and then B=3D'3' (for example) or B IS NULL.=20
>  =20
> Thanks for the answer.=20
>  =20
>  =20
> To Brice Ruth=20
>  =20
> I don't try that, but I supose yes. How can that case be connected with m=
y
> problem?=20
>  =20
> Thanks for your answer too.
> =20
>  =20
>  =20
>  =20
>  =20
> =20
> =20
>=20
>=20
>=20
>=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.