Return-Path: 
 <user-java-return-4036-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 28192 invoked from network); 30 Aug 2005 11:59:04 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 30 Aug 2005 11:59:04 -0000
Received: (qmail 16176 invoked by uid 500); 30 Aug 2005 11:59:02 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 16158 invoked by uid 500); 30 Aug 2005 11:59:02 -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 16142 invoked by uid 99); 30 Aug 2005 11:59:02 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 Aug 2005 04:59:02 -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 [83.247.21.91] (HELO wis.nl) (83.247.21.91)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 Aug 2005 04:59:17 -0700
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: IsNotEqual
X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0
Date: Tue, 30 Aug 2005 13:57:44 +0200
Message-ID: <50CA25BD6EEA954FA592C097399942E303F3568A@CM1.wis.local>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: IsNotEqual
thread-index: AcWtWdkN6qKMnTAoSfOxzHY/+H3fLwAAAQyw
From: "Niels Beekman" <n.beekman@wis.nl>
To: <user-java@ibatis.apache.org>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

You need to choose between compareProperty or compareValue...
What you are trying to do requires the following:

<IsNotEqual prepend=3D" OR " property=3D"test" compareValue=3D"-1"/>

The attribute compareProperty would be used to compare against another
property...

Niels

-----Original Message-----
From: Eugeny N Dzhurinsky [mailto:eugenydzh@jdevelop.com]=20
Sent: dinsdag 30 augustus 2005 13:57
To: user-java@ibatis.apache.org
Subject: IsNotEqual

I'm trying to execute
<select resultClass=3D"someclass" parameterClass=3D"soemclass">
    select * from table
    <dynamic prepend=3D" WHERE ">
	<IsNotEqual prepend=3D" OR " compareProperty=3D"test"
compareValue=3D"-1">
	    test =3D #test#
	</IsNotEqual>
    </dynamic>
</select>

The thing is if the test property in the object does have value set to
-1,=20
the IsNotEqual is appended to the SQL query for some reason.

The test property is declared as "int".

Any ideas?

--=20
Eugene N Dzhurinsky