Return-Path: 
 <user-java-return-7459-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 74567 invoked from network); 20 Jun 2006 04:35:43 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 20 Jun 2006 04:35:43 -0000
Received: (qmail 35565 invoked by uid 500); 20 Jun 2006 04:35:40 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 35547 invoked by uid 500); 20 Jun 2006 04:35:40 -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 35535 invoked by uid 99); 20 Jun 2006 04:35:40 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 19 Jun 2006 21:35:40 -0700
X-ASF-Spam-Status: No, hits=2.2 required=10.0
	tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,HTML_MESSAGE,MAILTO_TO_SPAM_ADDR
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [202.43.219.151] (HELO web8403.mail.in.yahoo.com)
 (202.43.219.151)
    by apache.org (qpsmtpd/0.29) with SMTP; Mon, 19 Jun 2006 21:35:38 -0700
Received: (qmail 72713 invoked by uid 60001); 20 Jun 2006 04:35:15 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.co.in;
  h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
  b=uU2cTls+L/fPYGSb6V2f+J/X2GNYqtJf3rFOEMY8924SdVnpdL8ERra5kR7T/gq5upMz+LOuPGnRE9LzT2ZDTO22vNTgAs4LbTTp0EM6eo/F4RNhVtS3WE//ZZSTAOzxBcbIBW6p+5NJZ1gPg7Om7spSQARqd95SRgb/zNzZLjk=
  ;
Message-ID: <20060620043515.72711.qmail@web8403.mail.in.yahoo.com>
Received: from [210.211.198.104] by web8403.mail.in.yahoo.com via HTTP;
 Tue, 20 Jun 2006 05:35:15 BST
Date: Tue, 20 Jun 2006 05:35:15 +0100 (BST)
From: puneet arya <puneet_arya_old@yahoo.co.in>
Subject: Re: IN (SQL), how to iterate?
To: user-java@ibatis.apache.org
In-Reply-To: <c593b8750606160528i29d40530i8deabf0c33cf3279@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1046905871-1150778115=:52046"
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-1046905871-1150778115=:52046
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

ok i didnt try iterate tag . may be it works more better .
                                                                  Puneet arya

Jeff Butler <jeffgbutler@gmail.com> wrote:
    This could work, but it's not the best way to do it.  You loose all the type capabilities of iBATIS and some types are not so easy to convert to strings.  It's much better to use the <iterate> tag.
   
  Jeff Butler

 
  On 6/15/06, puneet arya <puneet_arya_old@yahoo.co.in> wrote:       hi,
  
   SELECT name,branch,username
               FROM KXAccount
               WHERE id IN (#ids#)

  You can write in xml as 
   
  
     SELECT name,branch,username
               FROM KXAccount

                 WHERE id IN ($ids$)
   
  and in these id you have to capture as a string . if u didnt get , you just tell me teh full scenario i will give you the exact solution.




       eg sql: 
     
      SELECT name,branch,username
               FROM KXAccount
               WHERE id IN (#ids#)

 you can write as this:
   
   
      SELECT name,branch,username
               FROM KXAccount
     <iterate prepend="where" property="ids"open=" id in (" conjunction="," close=")" >
    #ids[]#
   </iterate>

 
  2006/6/15, xianwinwin <xianwinwin@gmail.com>:   
can anyone provide an exmple of how to use this statement with iBatis?

       SELECT name,branch,username 
       FROM KXAccount
       WHERE id IN ('234','655','411','775,'416')

the problem is in the IN clause: when I try this:

               SELECT name,branch,username
               FROM KXAccount
               WHERE id IN (#ids#)

I try this and while popuplating the #ids# with a string of:
'234','655','411','775,'416'
the result applies only to the first item (234).

does anyone know any exmple of IN which iterate through the object? 
thanks


--
View this message in context: http://www.nabble.com/IN-%28SQL%29%2C-how-to-iterate--t1789058.html#a4874196 
Sent from the iBATIS - User - Java forum at Nabble.com.





-- 
RenZenggang
Renzenggang@gmail.com 
Renzenggang@csii.com
MSN:rzg117@hotmail.com
Blog: http://rzg.itpub.net


    Send instant messages to your online friends http://in.messenger.yahoo.com 

Stay connected with your friends even when away from PC. Link: http://in.mobile.yahoo.com/new/messenger/   
  

    
---------------------------------
  Yahoo! India Answers: Share what you know. Learn something new Click here
Send free SMS to your Friends on Mobile from your Yahoo! Messenger Download now 
    
  





 				
---------------------------------
  Yahoo! India Answers: Share what you know. Learn something new Click here
 Send free SMS to your Friends on Mobile from your Yahoo! Messenger Download now
 				
---------------------------------
  Yahoo! India Answers: Share what you know. Learn something new Click here
 Send free SMS to your Friends on Mobile from your Yahoo! Messenger Download now
--0-1046905871-1150778115=:52046
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<div>ok i didnt try iterate tag . may be it works more better .</div>  <div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Puneet arya<BR><BR><B><I>Jeff Butler &lt;jeffgbutler@gmail.com&gt;</I></B> wrote:</div>  <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">  <DIV>This could work, but it's not the best way to do it.&nbsp; You loose all the type capabilities of iBATIS and some types are not so easy to convert to strings.&nbsp; It's much better to use the &lt;iterate&gt; tag.</DIV>  <DIV>&nbsp;</DIV>  <DIV>Jeff Butler<BR><BR>&nbsp;</DIV>  <DIV><SPAN class=gmail_quote>On 6/15/06, <B
 class=gmail_sendername>puneet arya</B> &lt;<A href="mailto:puneet_arya_old@yahoo.co.in">puneet_arya_old@yahoo.co.in</A>&gt; wrote:</SPAN>   <BLOCKQUOTE class=gmail_quote style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">  <DIV>  <DIV>hi,</DIV>  <DIV></DIV>  <DIV><SPAN class=q>&nbsp;SELECT name,branch,username<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FROM KXAccount<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WHERE id IN (#ids#)<BR></SPAN></DIV>  <DIV>You&nbsp;can write in xml as </DIV>  <DIV>&nbsp;</DIV>  <DIV></DIV>  <DIV><SPAN class=q>&nbsp;&nbsp;&nbsp;SELECT name,branch,username<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FROM KXAccount<BR></SPAN></DIV>  <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WHERE id IN ($ids$)</DIV>  <DIV>&nbsp;</DIV>  <DIV>and in these id you have to capture as a string . if u didnt get , you just tell me teh full scenario i will give you the exact
 solution.<BR><BR><BR><B><I></I></B></DIV></DIV>  <DIV><SPAN class=e id=q_10bdb1dc8ccd801e_5>  <BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">  <DIV>&nbsp;eg sql: </DIV>  <DIV>&nbsp;&nbsp; </DIV>  <DIV>&nbsp;&nbsp;&nbsp;&nbsp;SELECT name,branch,username<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FROM KXAccount<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WHERE id IN (#ids#)<BR><BR>&nbsp;you can write as this:</DIV>  <DIV>&nbsp;</DIV>  <DIV>&nbsp;</DIV>  <DIV>&nbsp;&nbsp;&nbsp;&nbsp;SELECT name,branch,username<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FROM KXAccount</DIV>  <DIV>&nbsp;&nbsp;&nbsp;&lt;iterate prepend="where"&nbsp;property="ids"open=" id in (" conjunction=","&nbsp;close=")" &gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;#ids[]#<BR>&nbsp;&nbsp;&nbsp;&lt;/iterate&gt;<BR><BR>&nbsp;</DIV>  <DIV><SPAN class=gmail_quote>2006/6/15, xianwinwin &lt;<A onclick="return
 top.js.OpenExtLink(window,event,this)" href="mailto:xianwinwin@gmail.com" target=_blank>xianwinwin@gmail.com</A>&gt;:</SPAN>   <BLOCKQUOTE class=gmail_quote style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><BR>can anyone provide an exmple of how to use this statement with iBatis?<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT name,branch,username <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM KXAccount<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE id IN ('234','655','411','775,'416')<BR><BR>the problem is in the IN clause: when I try this:<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT name,branch,username<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM KXAccount<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE id IN (#ids#)<BR><BR>I try this and while popuplating the #ids# with a string
 of:<BR>'234','655','411','775,'416'<BR>the result applies only to the first item (234).<BR><BR>does anyone know any exmple of IN which iterate through the object? <BR>thanks<BR><BR><BR>--<BR>View this message in context: <A onclick="return top.js.OpenExtLink(window,event,this)" href="http://www.nabble.com/IN-%28SQL%29%2C-how-to-iterate--t1789058.html#a4874196" target=_blank>http://www.nabble.com/IN-%28SQL%29%2C-how-to-iterate--t1789058.html#a4874196 </A><BR>Sent from the iBATIS - User - Java forum at <A onclick="return top.js.OpenExtLink(window,event,this)" href="http://nabble.com/" target=_blank>Nabble.com</A>.<BR><BR></BLOCKQUOTE></DIV><BR><BR clear=all><BR>-- <BR>RenZenggang<BR><A onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:Renzenggang@gmail.com" target=_blank>Renzenggang@gmail.com </A><BR><A onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:Renzenggang@csii.com" target=_blank>Renzenggang@csii.com</A><BR><A onclick="return
 top.js.OpenExtLink(window,event,this)" href="mailto:MSN:rzg117@hotmail.com" target=_blank>MSN:rzg117@hotmail.com</A><BR>Blog: <A onclick="return top.js.OpenExtLink(window,event,this)" href="http://rzg.itpub.net/" target=_blank>http://rzg.itpub.net</A><BR></BLOCKQUOTE><BR></SPAN></DIV>  <DIV>  <div>Send instant messages to your online friends <A onclick="return top.js.OpenExtLink(window,event,this)" href="http://in.messenger.yahoo.com/" target=_blank>http://in.messenger.yahoo.com</A> <BR><BR>Stay connected with your friends even when away from PC. Link: <A onclick="return top.js.OpenExtLink(window,event,this)" href="http://in.mobile.yahoo.com/new/messenger/" target=_blank>http://in.mobile.yahoo.com/new/messenger/</A>   <div></div>  <div></div></DIV>  <DIV><SPAN class=ad>  <HR SIZE=1>  Yahoo! India Answers: Share what you know. Learn something new <A onclick="return top.js.OpenExtLink(window,event,this)"
 href="http://us.rd.yahoo.com/mail/in/mailanswersshare/*http://in.answers.yahoo.com/" target=_blank>Click here</A><BR>Send free SMS to your Friends on Mobile from your Yahoo! Messenger <A onclick="return top.js.OpenExtLink(window,event,this)" href="http://us.rd.yahoo.com/mail/in/freesms/*http://messenger.yahoo.com/download.php" target=_blank>Download now</A> </SPAN></DIV>  <DIV>  <div></div>  <div></div></DIV></BLOCKQUOTE></DIV><BR></BLOCKQUOTE><BR><p> 
	

	
		<hr size=1></hr> 
 Yahoo! India Answers: Share what you know. Learn something new <a href="http://us.rd.yahoo.com/mail/in/mailanswersshare/*http://in.answers.yahoo.com/">Click here</a><br> 
Send free SMS to your Friends on Mobile from your Yahoo! Messenger <a href="http://us.rd.yahoo.com/mail/in/freesms/*http://messenger.yahoo.com/download.php">Download now</a><p>&#32;
	

	
		<hr size=1></hr> 
 Yahoo! India Answers: Share what you know. Learn something new <a href="http://us.rd.yahoo.com/mail/in/mailanswersshare/*http://in.answers.yahoo.com/">Click here</a><br> 
Send free SMS to your Friends on Mobile from your Yahoo! Messenger <a href="http://us.rd.yahoo.com/mail/in/freesms/*http://messenger.yahoo.com/download.php">Download now</a>
--0-1046905871-1150778115=:52046--