Return-Path: 
 <user-java-return-5715-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 51328 invoked from network); 26 Jan 2006 14:49:17 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 26 Jan 2006 14:49:17 -0000
Received: (qmail 35313 invoked by uid 500); 26 Jan 2006 14:49:11 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 35204 invoked by uid 500); 26 Jan 2006 14:49:11 -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 35108 invoked by uid 99); 26 Jan 2006 14:49:10 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 26 Jan 2006 06:49:10 -0800
X-ASF-Spam-Status: No, hits=0.8 required=10.0
	tests=DNS_FROM_RFC_ABUSE,HTML_MESSAGE,MAILTO_TO_SPAM_ADDR
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [206.190.39.67] (HELO web53513.mail.yahoo.com) (206.190.39.67)
    by apache.org (qpsmtpd/0.29) with SMTP; Thu, 26 Jan 2006 06:49:08 -0800
Received: (qmail 99658 invoked by uid 60001); 26 Jan 2006 14:48:47 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
  b=xXaKm8QOUQ/Fjs9fASr9tTTgtIUHJR7G6O9tR2Gla7fWloUCUD+fa1xqhQAJbgDlpiG35RRCMt/qqQhiMWbjB+hXT6NakQa/HpNN5aPnuYiRV2VQ4KF9Iibp951t9I19FsABlsx5NbAWn93zCQ0P54yGwqFXAC0me6EKpCUWDYQ=
  ;
Message-ID: <20060126144847.99656.qmail@web53513.mail.yahoo.com>
Received: from [65.207.191.131] by web53513.mail.yahoo.com via HTTP;
 Thu, 26 Jan 2006 06:48:47 PST
Date: Thu, 26 Jan 2006 06:48:47 -0800 (PST)
From: Rick Gray <rgray1955@yahoo.com>
Subject: Re: Using <dynamic> elements
To: user-java@ibatis.apache.org
In-Reply-To: <b2e941150601251344n460ceb76oeb81f99a0f58a978@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-693490582-1138286927=:99326"
Content-Transfer-Encoding: 8bit
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

--0-693490582-1138286927=:99326
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Mark, I need to know if i can build dynamic result maps and dynamic parameter maps using the <dynamic> element like you can in the statement.  In other words can i use the <dynamic>, <IsNotNull> and other dynamic elements in the result and parameter maps? The section of code below was taken from the dynamic statement example in the manual.
   
    <dynamic prepend="WHERE">
  <isNotNull prepend="AND" property="firstName">
  (ACC_FIRST_NAME = #firstName#
  <isNotNull prepend="OR" property="lastName">
  ACC_LAST_NAME = #lastName#
  </isNotNull>
  )
  </isNotNull>
  <isNotNull prepend="AND" property="emailAddress">
  ACC_EMAIL like #emailAddress#
  </isNotNull>
  <isGreaterThan prepend="AND" property="id" compareValue="0">
  ACC_ID = #id#
  </isGreaterThan>
  </dynamic>
   


Mark Bennett <mark.bennett.mail@gmail.com> wrote:
  You can extend resultmaps which allow you to factor similar fields but allow special handling for separate fields.

<resultMap id="myResult" extends="BaseMap" class="myClass">
        <result property="special" column="specialCol" select=" Namespace.getFromSomeWhere"/>
</resultMap>

Mark


  On 1/25/06, Rick Gray <rgray1955@yahoo.com > wrote:    Hi,
   
  I'm evaluating IBATIS for use in our project. I need to know if I can use <dynamic> elements in the ParameterMaps and ResultMaps. I want to keep the parameters and results in sync with the statement. 
   
  Thanks
   
  Rick 
  __________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


  


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
--0-693490582-1138286927=:99326
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<DIV>Mark, I need to know if i can build dynamic result maps and dynamic parameter maps using the &lt;dynamic&gt; element like you can in the statement.&nbsp; In other words can i use the &lt;dynamic&gt;, &lt;IsNotNull&gt; and other dynamic elements in the result and parameter maps? The section of code below was taken from the dynamic statement example in the manual.</DIV>  <DIV>&nbsp;</DIV>  <DIV><B><FONT face=Arial-BoldMT size=1>  <div align=left>&lt;dynamic prepend="</FONT><FONT face=Arial-BoldMT color=#0000ff size=1>WHERE</FONT><FONT face=Arial-BoldMT size=1>"&gt;</div>  <div align=left>&lt;isNotNull prepend="</FONT><FONT face=Arial-BoldMT color=#0000ff size=1>AND</FONT><FONT face=Arial-BoldMT size=1>" property="firstName"&gt;</div></FONT><FONT face=Arial-BoldMT color=#0000ff size=1>  <div align=left>(ACC_FIRST_NAME = #firstName#</div></FONT><FONT face=Arial-BoldMT size=1>  <div align=left>&lt;isNotNull prepend="</FONT><FONT face=Arial-BoldMT color=#0000ff size=1>OR</FONT
 ><FONT
 face=Arial-BoldMT size=1>" property="lastName"&gt;</div></FONT><FONT face=Arial-BoldMT color=#0000ff size=1>  <div align=left>ACC_LAST_NAME = #lastName#</div></FONT><FONT face=Arial-BoldMT size=1>  <div align=left>&lt;/isNotNull&gt;</div></FONT><FONT face=Arial-BoldMT color=#0000ff size=1>  <div align=left>)</div></FONT><FONT face=Arial-BoldMT size=1>  <div align=left>&lt;/isNotNull&gt;</div>  <div align=left>&lt;isNotNull prepend="</FONT><FONT face=Arial-BoldMT color=#0000ff size=1>AND</FONT><FONT face=Arial-BoldMT size=1>" property="emailAddress"&gt;</div></FONT><FONT face=Arial-BoldMT color=#0000ff size=1>  <div align=left>ACC_EMAIL like #emailAddress#</div></FONT><FONT face=Arial-BoldMT size=1>  <div align=left>&lt;/isNotNull&gt;</div>  <div align=left>&lt;isGreaterThan prepend="</FONT><FONT face=Arial-BoldMT color=#0000ff size=1>AND</FONT><FONT face=Arial-BoldMT size=1>" property="id" compareValue="0"&gt;</div></FONT><FONT face=Arial-BoldMT color=#0000ff size=1>  <div
 align=left>ACC_ID = #id#</div></FONT><FONT face=Arial-BoldMT size=1>  <div align=left>&lt;/isGreaterThan&gt;</div>  <div align=left>&lt;/dynamic&gt;</div></FONT><FONT face=Arial-BoldMT color=#0000ff size=1>  <div align=left>&nbsp;</div></B></FONT><BR><BR><B><I>Mark Bennett &lt;mark.bennett.mail@gmail.com&gt;</I></B> wrote:</DIV>  <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">You can extend resultmaps which allow you to factor similar fields but allow special handling for separate fields.<BR><BR>&lt;resultMap id="myResult" extends="BaseMap" class="myClass"&gt;<BR>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;result property="special" column="specialCol" select=" Namespace.getFromSomeWhere"/&gt;<BR>&lt;/resultMap&gt;<BR><BR>Mark<BR><BR><BR>  <DIV><SPAN class=gmail_quote>On 1/25/06, <B class=gmail_sendername>Rick Gray</B> &lt;<A href="mailto:rgray1955@yahoo.com">rgray1955@yahoo.com </A>&gt; wrote:</SPAN>  <BLOCKQUOTE class=gmai
 l_quote
 style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">  <DIV>Hi,</DIV>  <DIV>&nbsp;</DIV>  <DIV>I'm evaluating IBATIS for use in our project. I need to know if I can use &lt;dynamic&gt; elements in the ParameterMaps and ResultMaps. I want to keep the parameters and results in sync with the statement. </DIV>  <DIV>&nbsp;</DIV>  <DIV>Thanks</DIV><SPAN class=sg>  <DIV>&nbsp;</DIV>  <DIV>Rick&nbsp;</DIV></SPAN><SPAN class=ad>  <div>__________________________________________________<BR>Do You Yahoo!?<BR>Tired of spam? Yahoo! Mail has the best spam protection around <BR><A onclick="return top.js.OpenExtLink(window,event,this)" href="http://mail.yahoo.com/" target=_blank>http://mail.yahoo.com</A> </div></SPAN></BLOCKQUOTE></DIV><BR></BLOCKQUOTE>  <DIV><BR></DIV><p>__________________________________________________<br>Do You Yahoo!?<br>Tired of spam?  Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com 
--0-693490582-1138286927=:99326--