Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of larry.meadors@gmail.com
 designates 66.249.92.173 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:reply-to:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth;
        b=CDUDRYVDdrs0SR1kDk7F262ppccKsxAU6xcOQZO4tcfOzoaBFGMk58YwIi2Wi/jpUVfI9ubF41O7xkc0DAWzi67O29aW8Ex3rEuYgY85n9FdYwvecgE6ELh5m4RVpltoxgeLxcA/hpNS05u69QoSSx2X7y2Y6n9KxTB3Ml+J2+o=
Message-ID: <a10a823c0710050658u4aae5e63j76b309835f42ad04@mail.gmail.com>
Date: Fri, 5 Oct 2007 07:58:05 -0600
From: "Larry Meadors" <lmeadors@apache.org>
Reply-To: lmeadors@apache.org
Sender: larry.meadors@gmail.com
To: user-java@ibatis.apache.org
Subject: Re: Help needed for representing complex business relationship
In-Reply-To: <13058357.post@talk.nabble.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <13056406.post@talk.nabble.com>
	 <a10a823c0710050503w7137fa59p241defdde2d5518c@mail.gmail.com>
	 <13058357.post@talk.nabble.com>

Sounds like you could use a sub-select.

Larry


On 10/5/07, Amol Chaudhari <avchaudhari@gmail.com> wrote:
>
> Larry,
> thanks for the reply.
> The issue is i have in the topmost section, few values which are calculated
> from the child lists. So the lists are needed at the time of calculations
> itself.
>
> Anyway, Can you please help me on the following issue:
> Lets say i have a Business object A having a1, a2, a3, a4,a5,a6 as instance
> variables. I am getting a1 and a2 from my initial query. Now, a3,a4 are the
> calculated fields, whose values i can get from another (single) query. also
> a5 is a calculated field whose value also i can get from one more query. and
> a6 = a3+a4+a5 (some formula like this).
> My question is, how can i map the a3,a4 fileds in the resultMap of my
> initial query so that i can populate both the values from a single query?
>
> Regards,
> Amol
> --
> View this message in context: http://www.nabble.com/Help-needed-for-representing-complex-business-relationship-tf4574170.html#a13058357
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>