Return-Path: 
 <user-java-return-4079-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 23321 invoked from network); 2 Sep 2005 04:49:26 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 2 Sep 2005 04:49:26 -0000
Received: (qmail 63314 invoked by uid 500); 2 Sep 2005 04:49:25 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 63293 invoked by uid 500); 2 Sep 2005 04:49:24 -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 63280 invoked by uid 99); 2 Sep 2005 04:49:24 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Sep 2005 21:49:24 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of larry.meadors@gmail.com
 designates 64.233.162.193 as permitted sender)
Received: from [64.233.162.193] (HELO zproxy.gmail.com) (64.233.162.193)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Sep 2005 21:49:38 -0700
Received: by zproxy.gmail.com with SMTP id s1so215308nze
        for <user-java@ibatis.apache.org>;
 Thu, 01 Sep 2005 21:49:21 -0700 (PDT)
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=VFI/6W3nMpMSgumxwLo6emo32ZYmGXSHmccOQk9uubiy8I6aW/rUz1JKzAN/ZQ6/Mzz30NofOjvIk9TeZR78btK1mjtGwo7brEfMY9cMmlHI/OU5zkGUWtBCBVINVD3i71jveNd13EjA2Hy6yV6yU/bFlULABnnyONHArobDiI8=
Received: by 10.36.138.18 with SMTP id l18mr1814583nzd;
        Thu, 01 Sep 2005 21:49:21 -0700 (PDT)
Received: by 10.36.118.10 with HTTP; Thu, 1 Sep 2005 21:49:20 -0700 (PDT)
Message-ID: <a10a823c05090121495cedcc87@mail.gmail.com>
Date: Thu, 1 Sep 2005 22:49:20 -0600
From: Larry Meadors <larry.meadors@gmail.com>
Reply-To: lmeadors@apache.org
To: user-java@ibatis.apache.org
Subject: Re: More than one parameter class/map for the <select> element ?
In-Reply-To: <20050902033836.72846.qmail@unknown-206-190-39-12.yahoo.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <20050902033836.72846.qmail@unknown-206-190-39-12.yahoo.com>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

By creating a composite class, or using a Map.

public class Foo{
  private YourClassA yourClassA;
  private YourClassB yourClassB;
  // getters and setters below...
}

Larry


On 9/1/05, Mathew Samuel <grandarchville@yahoo.com> wrote:
>=20
> Is it possible to pass a 2nd custom/standard class
> through a queryForObject() or queryForList() ? Or do I
> have to combine both objects under a Collection before
> sending it in ? I would want to use certain properties
> from the 2nd class to aid the 1st in a join, like
> shown below:
>=20
>=20
>   <resultMap id=3D"tableAResult" class=3D"objectA">
>    ...
>   </resultMap>
>=20
>   <select id=3D"anId" resultMap=3D"tableAResult"
> parameterClass=3D"objectA">
>     select TableA.field1, TableA.field2
>     from TableA, TableB
>     where TableA.field3 =3D TableB.field1
>     and TableA.field4 =3D #propertyOfObjectA#
>     and TableB.field2 =3D #someStringNotPartofObjectA#
>   </select>
>=20
> How is this acheived ?
>=20
>=20
>=20
> ____________________________________________________
> Start your day with Yahoo! - make it your home page
> http://www.yahoo.com/r/hs
>=20
>