Return-Path: 
 <user-cs-return-2016-apmail-ibatis-user-cs-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-cs-archive@www.apache.org
Received: (qmail 96536 invoked from network); 28 Nov 2006 11:24:43 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 28 Nov 2006 11:24:43 -0000
Received: (qmail 95751 invoked by uid 500); 28 Nov 2006 11:24:52 -0000
Delivered-To: apmail-ibatis-user-cs-archive@ibatis.apache.org
Received: (qmail 95738 invoked by uid 500); 28 Nov 2006 11:24:52 -0000
Mailing-List: contact user-cs-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-cs-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-cs-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-cs@ibatis.apache.org>
List-Id: <user-cs.ibatis.apache.org>
Reply-To: user-cs@ibatis.apache.org
Delivered-To: mailing list user-cs@ibatis.apache.org
Received: (qmail 95727 invoked by uid 99); 28 Nov 2006 11:24:52 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 28 Nov 2006 03:24:52 -0800
X-ASF-Spam-Status: No, hits=2.0 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: domain of jakub.scheibe@gmail.com
 designates 66.249.82.235 as permitted sender)
Received: from [66.249.82.235] (HELO wx-out-0506.google.com) (66.249.82.235)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 28 Nov 2006 03:24:39 -0800
Received: by wx-out-0506.google.com with SMTP id t14so1955683wxc
        for <user-cs@ibatis.apache.org>; Tue, 28 Nov 2006 03:24:19 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=N27cdSKBowGiYPTfpx9ccST7hHTY+HI8XzAsAAOa9MkZgin13Zu9yqvGxbQtyflC6kEAYQkuajnm0/6QgXjJyb0Ob5QSY02PGtkW0VZ+R7/WOvEhGUFIuW+BaklbQsXN8P0zfEH8zlcEDKbg7FtwCJ4Xn/lGXHbiWB0VwAe0GWE=
Received: by 10.70.34.3 with SMTP id h3mr1535891wxh.1164713059068;
        Tue, 28 Nov 2006 03:24:19 -0800 (PST)
Received: by 10.70.105.7 with HTTP; Tue, 28 Nov 2006 03:24:19 -0800 (PST)
Message-ID: <32163a230611280324w5d5350del15f27fbf197583ed@mail.gmail.com>
Date: Tue, 28 Nov 2006 11:24:19 +0000
From: "Jakub Scheibe" <jakub.scheibe@gmail.com>
To: user-cs@ibatis.apache.org
Subject: Re: Dynamic ResultMaps
In-Reply-To: 
 <ACEC0E8E588A6A40BD2026CA63D74966865DBB@v2mailserver.in.v2solutions.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_4027_28809761.1164713059028"
References: 
 <ACEC0E8E588A6A40BD2026CA63D74966865DBB@v2mailserver.in.v2solutions.com>
X-Virus-Checked: Checked by ClamAV on apache.org

------=_Part_4027_28809761.1164713059028
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

When I'm using my class as a resultclass i'm only getting
null values :(

On 28/11/06, Nikhil Vaghela <nikhil.vaghela@in.v2solutions.com> wrote:
>
>  Hi ,
>
>
>
> In such situation you can use resultClass instead of resultMap , and in
> that case you should have your property [in your custom objects] names same
> as your query's fields name.
>
>
>
> Nikhil.
>  ------------------------------
>
> *From:* Jakub Scheibe [mailto:jakub.scheibe@gmail.com]
> *Sent:* Tuesday, November 28, 2006 4:42 PM
> *To:* user-cs@ibatis.apache.org
> *Subject:* Dynamic ResultMaps
>
>
>
> Hi,
>
> Is there any way to create dynamic resultmaps?
> In this moment i'm preparing dynamic sql statement but I don't know how to
> prepare dynamic resultmap
>
> Here is how i'm doing this:
>
>         <select id="Select" parameterclass="MyClass" resultmap="MyResMap">
>
>             select
>             <dynamic>
>                 <isEqual property="Id" compareValue="1">
>                     ID
>                 </isEqual>
>                 <isEqual property="Name" compareValue="true" prepend=",">
>                     NAME
>                 </isEqual>
>             </dynamic>
>             from MYTBL
>         </select>
>
> if I use following resultmap it working ok but i need to use both Id and
> Name in Select
>
>         <resultMap id="MyResMap">
>                 <result property="Id" column="ID"/>
>                 <result property="Name" column="Name"/>
>         </resultMap>
>
> Regards,
> Jakub
>

------=_Part_4027_28809761.1164713059028
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

When I'm using my class as a resultclass i'm only getting<br>null values :(<br><br><div><span class="gmail_quote">On 28/11/06, <b class="gmail_sendername">Nikhil Vaghela</b> &lt;<a href="mailto:nikhil.vaghela@in.v2solutions.com">
nikhil.vaghela@in.v2solutions.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">










<div link="blue" vlink="purple" lang="EN-US">

<div>

<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Hi , </span></font></p>

<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">&nbsp;</span></font></p>

<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">In such situation you can use resultClass
instead of resultMap , and in that case you should have your property [in your
custom objects] names same as your query's fields name.</span></font></p>

<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">&nbsp;</span></font></p>

<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Nikhil.</span></font></p>

<div>

<div style="text-align: center;" align="center"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">

<hr align="center" size="2" width="100%">

</span></font></div>

<p><b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold;">From:</span></font></b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;"> Jakub Scheibe
[mailto:<a href="mailto:jakub.scheibe@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">jakub.scheibe@gmail.com</a>] <br>
<b><span style="font-weight: bold;">Sent:</span></b> Tuesday, November 28, 2006
4:42 PM<br>
<b><span style="font-weight: bold;">To:</span></b> <a href="mailto:user-cs@ibatis.apache.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">user-cs@ibatis.apache.org</a><br>
<b><span style="font-weight: bold;">Subject:</span></b> Dynamic ResultMaps</span></font></p>

</div><div><span class="e" id="q_10f2e47ac21df196_1">

<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;">&nbsp;</span></font></p>

<p style="margin-bottom: 12pt;"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Hi,<br>
<br>
Is there any way to create dynamic resultmaps?<br>
In this moment i'm preparing dynamic sql statement but I don't know how to
prepare dynamic resultmap<br>
<br>
Here is how i'm doing this:<br>
<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;select id=&quot;Select&quot;
parameterclass=&quot;MyClass&quot; resultmap=&quot;MyResMap&quot;&gt; <br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; select<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;dynamic&gt;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&lt;isEqual property=&quot;Id&quot; compareValue=&quot;1&quot;&gt;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; ID<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&lt;/isEqual&gt;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&lt;isEqual property=&quot;Name&quot; compareValue=&quot;true&quot;
prepend=&quot;,&quot;&gt; <br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
NAME<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&lt;/isEqual&gt;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;/dynamic&gt;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; from MYTBL<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;/select&gt;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; <br>
<br>
if I use following resultmap it working ok but i need to use both Id and Name
in Select <br>
<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;resultMap id=&quot;MyResMap&quot;&gt;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&lt;result property=&quot;Id&quot; column=&quot;ID&quot;/&gt;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&lt;result property=&quot;Name&quot; column=&quot;Name&quot;/&gt; <br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;/resultMap&gt;<br>
<br>
Regards,<br>
Jakub</span></font></p>

</span></div></div>

</div>



</blockquote></div><br>

------=_Part_4027_28809761.1164713059028--