Return-Path: 
 <dev-return-2261-apmail-ibatis-dev-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-dev-archive@www.apache.org
Received: (qmail 41037 invoked from network); 23 Dec 2005 14:21:58 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 23 Dec 2005 14:21:57 -0000
Received: (qmail 57082 invoked by uid 500); 23 Dec 2005 14:21:55 -0000
Delivered-To: apmail-ibatis-dev-archive@ibatis.apache.org
Received: (qmail 57056 invoked by uid 500); 23 Dec 2005 14:21:55 -0000
Mailing-List: contact dev-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@ibatis.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@ibatis.apache.org>
List-Post: <mailto:dev@ibatis.apache.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: dev@ibatis.apache.org
Delivered-To: mailing list dev@ibatis.apache.org
Received: (qmail 57043 invoked by uid 500); 23 Dec 2005 14:21:55 -0000
Delivered-To: apmail-incubator-ibatis-dev@incubator.apache.org
Received: (qmail 57039 invoked by uid 99); 23 Dec 2005 14:21:55 -0000
X-ASF-Spam-Status: No, hits=1.3 required=10.0
	tests=SPF_FAIL
X-Spam-Check-By: apache.org
Received: from [192.87.106.226] (HELO ajax.apache.org) (192.87.106.226)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 Dec 2005 06:21:53 -0800
Received: from ajax.apache.org (ajax.apache.org [127.0.0.1])
	by ajax.apache.org (Postfix) with ESMTP id 7E846C9
	for <ibatis-dev@incubator.apache.org>; Fri, 23 Dec 2005 15:21:32 +0100 (CET)
Message-ID: <60221227.1135347692291.JavaMail.jira@ajax.apache.org>
Date: Fri, 23 Dec 2005 15:21:32 +0100 (CET)
From: "Martin Zeltner (JIRA)" <ibatis-dev@incubator.apache.org>
To: ibatis-dev@incubator.apache.org
Subject: [jira] Updated: (IBATIS-238) Property of a bean from a list can not
 be used in a dynamic query in elements isEquals and so on
In-Reply-To: <38544221.1135347570811.JavaMail.jira@ajax.apache.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
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

     [ http://issues.apache.org/jira/browse/IBATIS-238?page=all ]

Martin Zeltner updated IBATIS-238:
----------------------------------

    Attachment: baseprobe_patch.txt

Here my patch for this.

> Property of a bean from a list can not be used in a dynamic query in elements isEquals and so on
> ------------------------------------------------------------------------------------------------
>
>          Key: IBATIS-238
>          URL: http://issues.apache.org/jira/browse/IBATIS-238
>      Project: iBatis for Java
>         Type: Bug
>   Components: SQL Maps
>     Versions: 2.1.6
>  Environment: WinXp
>     Reporter: Martin Zeltner
>     Priority: Critical
>  Attachments: baseprobe_patch.txt
>
> A property of a bean that is in a list can not be used for testing. See attribute "property" of elements "isEquals" from example below:
>     <select id="searchKeywords" resultMap="keyword" parameterClass="list">
>         select KEYID, NAME, DESCRIPTION, OPTIMISTICLOCKINGVERSION from KEYWORDS
>         <iterate prepend="where" conjunction="and">
>             <isEqual property="[].type" compareValue="like">
>                 <isEqual property="[].field" compareValue="name">
>                     <isEqual property="[].caseSensitive" compareValue="true">
>                         NAME like #[].stringValue#
>                     </isEqual>
>                     <isNotEqual property="[].caseSensitive" compareValue="true">
>                         upper(NAME) like upper(#[].stringValue#)
>                     </isNotEqual>
>                 </isEqual>
>                 <isEqual property="[].field" compareValue="description">
>                     <isEqual property="[].caseSensitive" compareValue="true">
>                         DESCRIPTION like #[].stringValue#
>                     </isEqual>
>                     <isNotEqual property="[].caseSensitive" compareValue="true">
>                         upper(DESCRIPTION) like upper(#[].stringValue#)
>                     </isNotEqual>
>                 </isEqual>
>             </isEqual>
>         </iterate>
>         order by NAME
>     </select>
> Regards,
> Martin

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira