Return-Path: 
 <user-java-return-12006-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 86862 invoked from network); 5 Jul 2007 15:35:01 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 5 Jul 2007 15:35:01 -0000
Received: (qmail 5083 invoked by uid 500); 5 Jul 2007 15:34:59 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 5071 invoked by uid 500); 5 Jul 2007 15:34:59 -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 5058 invoked by uid 99); 5 Jul 2007 15:34:59 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Jul 2007 08:34:59 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: local policy)
Received: from [208.44.121.252] (HELO investoranalytics.com) (208.44.121.252)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Jul 2007 08:34:54 -0700
Received: from [10.1.1.11] (HELO [10.1.1.11])
  by investoranalytics.com (CommuniGate Pro SMTP 4.3.7)
  with ESMTP id 2733532 for user-java@ibatis.apache.org;
 Thu, 05 Jul 2007 11:34:31 -0400
Message-ID: <468D0F89.4040809@investoranalytics.com>
Date: Thu, 05 Jul 2007 11:34:33 -0400
From: Lisa Jenkins <lisa.jenkins@investoranalytics.com>
User-Agent: Thunderbird 1.5.0.4 (Macintosh/20060516)
MIME-Version: 1.0
To: user-java@ibatis.apache.org
Subject: Re: Inner select statements in resultMaps
References: <E634BD8FC83F4C4682DFCDAC1496F76E056CF6DF@perexc14.internal.dom>
In-Reply-To: <E634BD8FC83F4C4682DFCDAC1496F76E056CF6DF@perexc14.internal.dom>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Checked: Checked by ClamAV on apache.org

Hi paul,

Why not just hard code it in the query ?

      *select ORD_ID, ORD_CST_ID*
      *from PAYMENT*
      *where/ PAY_ORD_ID/ = #itemId#*
      *and/ PAY_CST_TYPE/ = **/'BIG_SPENDER'/*




MCCORMICK, Paul wrote:
>
> Dear List,
> I'm using lazy loading for inner select statements in results maps. Is 
> it possible to hard code a parameter that�s passed to the inner select 
> statement. See below. I would like the string "BIG_SPENDER" to be 
> passed to the query* getOrderPayments*. Is this possible?
>
> *<resultMap id=�get-order-result� class=�com.ibatis.example.Order�>*
>
>       *<result property=�id� column=�ORD_ID�/>*
>       *<result property=�customerId� column=�ORD_CST_ID�/>*
>       *<result property=�payments� column=�/{itemId=ORD_ID,/
>       custType/='BIG_SPENDER'}/� select=�getOrderPayments�/>*
>
> *</resultMap>*
>
> *<select id=�getOrderPayments� resultMap=�get-payment-result�>*
>
>       *select ORD_ID, ORD_CST_ID*
>       *from PAYMENT*
>       *where/ PAY_ORD_ID/ = #itemId#*
>       *and/ PAY_CST_TYPE/ = #custType#*
>
> *</select>*
>
>
> Thanks,
> Paul
>
> "DISCLAIMER: This email, including any attachments, is intended only 
> for use by the addressee(s) and may contain confidential and/or 
> personal information and may also be the subject of legal privilege. 
> If you are not the intended recipient, you must not disclose or use 
> the information contained in it. In this case, please let me know by 
> return email, delete the message permanently from your system and 
> destroy any copies.
>
> Before you take any action based upon advice and/or information 
> contained in this email you should carefully consider the advice and 
> information and consider obtaining relevant independent advice.
>