ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher.Mathru...@sybase.com
Subject RE: Need help on nested N + 1 query
Date Tue, 28 Nov 2006 18:14:19 GMT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:v = "urn:schemas-microsoft-com:vml" xmlns:o = 
"urn:schemas-microsoft-com:office:office" xmlns:w = 
"urn:schemas-microsoft-com:office:word" xmlns:st1 = 
"urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META urn:content-classes:message Content-class: 
boundary="----_=_NextPart_001_01C71318.2B39B05B" alternative; multipart 
Content-Type:>
<META http-equiv=Content-Type content="text/html; charset=us-ascii" 
Content-Type: ------_="_NextPart_001_01C71318.2B39B05B" html; text 
quoted-printable Content-Transfer-Encoding:>
<META content="MSHTML 6.00.2900.2995" name=GENERATOR></HEAD>
<BODY lang=EN-US vLink=blue link=blue>
<DIV dir=ltr align=left><FONT color=#0000ff size=2><SPAN 
class=370551318-28112006>How about searching the archives?</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2><SPAN 
class=370551318-28112006><A 
href="http://www.mail-archive.com/user-java@ibatis.apache.org/">http://www.mail-archive.com/user-java@ibatis.apache.org/</A></SPAN></FONT></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> "Tamilselvan Radha Krishnan" 
&lt;Tamilselvan.RadhaKrishnan@igate.com&gt; [mailto:"Tamilselvan Radha Krishnan" 
&lt;Tamilselvan.RadhaKrishnan@igate.com&gt;] <BR><B>Sent:</B> Tuesday,
November 
28, 2006 10:12 AM<BR><B>To:</B> 
&lt;user-java@ibatis.apache.org&gt;<BR><B>Subject:</B> RE: Need
help on nested N 
+ 1 query<BR></FONT><BR></DIV>
<DIV></DIV>
<META content="Microsoft Word 11 (filtered medium)" name=Generator><!--[if !mso]>
<STYLE>v\:* {
	BEHAVIOR: url(#default#VML)
}
o\:* {
	BEHAVIOR: url(#default#VML)
}
w\:* {
	BEHAVIOR: url(#default#VML)
}
.shape {
	BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]--><o:SmartTagType name="PersonName" 
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><!--[if
!mso]>
<STYLE>st1\:* {
	BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
	font-family: Tahoma;
}
@font-face {
	font-family: Verdana;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
	FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
	FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
	FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
	COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
	COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
	COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
	COLOR: blue; TEXT-DECORATION: underline
}
P {
	FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman"; mso-margin-top-alt:
auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle19 {
	COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply
}
DIV.Section1 {
	page: Section1
}
</STYLE>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext="edit">
  <o:idmap v:ext="edit" data="1" />
 </o:shapelayout></xml><![endif]-->
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN 
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Hi 
Jeff,<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN 
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Sorry I guess my mail 
box should have bounced as I didn&#8217;t receive response for the help I requested. 
Can you please let me know where can I see those suggestions if I have not 
received my email. Thanks.<o:p></o:p></SPAN></FONT></P>
<DIV>
<P><B><FONT face=Arial color=navy size=2><SPAN 
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Regards</SPAN></FONT></B><FONT

color=navy><SPAN style="COLOR: navy"> <o:p></o:p></SPAN></FONT></P>
<P><B><FONT face=Arial color=navy size=2><SPAN 
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Tamil</SPAN></FONT></B><FONT

color=navy><SPAN style="COLOR: navy"> <BR></SPAN></FONT><FONT
face=Verdana 
color=gray size=1><SPAN 
style="FONT-SIZE: 7.5pt; COLOR: gray; FONT-FAMILY: Verdana">|Technical Lead| 
iGATE Global Solutions Limited|Office: 52250000 Extn 2271| </SPAN></FONT><FONT

color=navy><SPAN style="COLOR: navy"><A 
href="mailto:tamilselvan.radhakrishnan@igate.com"><FONT face=Verdana 
size=1><SPAN 
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Verdana">tamilselvan.radhakrishnan@igate.com</SPAN></FONT></A></SPAN></FONT><FONT

face=Verdana color=gray size=1><SPAN 
style="FONT-SIZE: 7.5pt; COLOR: gray; FONT-FAMILY: Verdana">|</SPAN></FONT><FONT

color=navy><SPAN style="COLOR: navy"> </SPAN></FONT><FONT face=Verdana

color=gray size=1><SPAN 
style="FONT-SIZE: 7.5pt; COLOR: gray; FONT-FAMILY: Verdana">106-109, MAC 
Commerce park, Anna Salai, Guindy, Chennai 600032 India | 
Website:</SPAN></FONT><FONT color=navy><SPAN style="COLOR: navy">

</SPAN></FONT><FONT face=Verdana color=navy size=1><SPAN 
style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: Verdana">www.igate.com</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT 
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal><B><FONT face=Tahoma size=2><SPAN 
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT

face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> Jeff 
Butler [mailto:jeffgbutler@gmail.com] <BR><B><SPAN 
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Tuesday, November 28, 2006 10:56

PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> <st1:PersonName

w:st="on">user-java@ibatis.apache.org</st1:PersonName><BR><B><SPAN

style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: Need help on nested N + 1

query</SPAN></FONT><o:p></o:p></P></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN 
style="FONT-SIZE: 12pt"><o:p>&nbsp;</o:p></SPAN></FONT></P>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN 
style="FONT-SIZE: 12pt">Please stop asking the same question over and over 
again!<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN 
style="FONT-SIZE: 12pt">&nbsp;<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN 
style="FONT-SIZE: 12pt">If you want some help, reply to some of the suggestions 
that were offered the first time you asked this 
question.<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN 
style="FONT-SIZE: 12pt">&nbsp;<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN 
style="FONT-SIZE: 12pt">Jeff Butler<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN 
style="FONT-SIZE: 12pt"><BR><BR>&nbsp;<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal><SPAN class=gmailquote><FONT face="Times New Roman" 
size=3><SPAN style="FONT-SIZE: 12pt">On 11/28/06, <B><SPAN 
style="FONT-WEIGHT: bold">Tamilselvan Radha Krishnan</SPAN></B> &lt;<A

href="mailto:Tamilselvan.RadhaKrishnan@igate.com">Tamilselvan.RadhaKrishnan@igate.com</A>&gt;

wrote:</SPAN></FONT></SPAN> <o:p></o:p></P>
<DIV>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi,</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I've written a N + 1 query in Ibatis 
such a way that it will return the nested results as below 
:</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;&nbsp; Customer &#8211; First

object</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

DealFacility &#8211; An array list of objects within 
Customer</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Facility &#8211; An array list of objects within 
DealFacility</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

LoanInfo &#8211; An array list of objects within Facility</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;&nbsp;&nbsp; 
</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">The

Customer object is having a 'strCustomerId' as an attribute.&nbsp; I need to use 
this 'strCustomerId' in the WHERE clause of the query used for populating 
'LoanInfo'&nbsp; (&lt;select id="getFacilityLoans"&nbsp; )&nbsp; i.e, 3 level

below the Customer, in addition to 'Facility' class 
above.</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I've placed my Login.xml query 
below.&nbsp;</SPAN></FONT> <o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&lt;resultMap id="customersResults" 
class="com.ge.cf.myaccounts.domain.Customer"&gt; </SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&lt;result property="strCustomerId" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

column="CUSTOMER_CODE"/&gt;</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&lt;result property="strCustomerName" &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp; 
column="CUSTOMER_NAME"/&gt;</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&lt;result property="alDealFacilities"&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; column="CUSTOMER_CODE"&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
select="Login.getDealFacilities"/&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;&nbsp; 
&lt;/resultMap&gt;</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;&nbsp; 
</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;&nbsp; &lt;select 
id="getCustomerDetails"&nbsp; resultMap="customersResults"&nbsp; 
parameterClass="com.ge.cf.myaccounts.domain.Customer"&gt;</SPAN></FONT> 
<o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp; SELECT&nbsp;&nbsp; 
CUSTOMER_CODE,CUSTOMER_NAME</SPAN></FONT><o:p></o:p></P>
<P><FONT face="Times New Roman" size=3><SPAN 
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></FONT><FONT
face=Arial 
size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">FROM&nbsp;&nbsp;&nbsp;&nbsp;

STG_INTM_CUSTOMER_INFO </SPAN></FONT><o:p></o:p></P>
<P><FONT face="Times New Roman" size=3><SPAN 
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></FONT><FONT
face=Arial 
size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">WHERE&nbsp;&nbsp;&nbsp;

CUSTOMER_CODE=#strCustomerId#&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;&nbsp; &lt;/select&gt;&nbsp;

</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;&nbsp; 
..</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">..</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">..</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&lt;select 
id="getDealFacilities"&nbsp; resultMap="dealFacilityResults"&nbsp; 
parameterClass="java.lang.String"&gt;&nbsp; (selecting Facilities here) 
</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&lt;select id="getFacilities"&nbsp;

resultMap="facilityResults"&nbsp; 
parameterClass="java.lang.String"&gt;&nbsp;&nbsp; (Selecting facility loans 
here) </SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&lt;select 
id="getFacilityLoans"&nbsp; resultMap="facilityLoanResults"&nbsp; 
parameterClass="java.lang.String"&gt;&nbsp; (In this query, I need to use the 
"strCustomerId" from the first Customer object within the N+1 query. 
</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Any

suggestion would be much helpful.</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Regards,</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Tamil</SPAN></FONT><o:p></o:p></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN 
style="FONT-SIZE: 12pt"><o:p>&nbsp;</o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><FONT face="Times New Roman" 
size=3><SPAN style="FONT-SIZE: 12pt"><BR><BR><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><FONT face="Times New Roman" 
size=3><SPAN style="FONT-SIZE: 12pt"><o:p>&nbsp;</o:p></SPAN></FONT></P>
<TABLE class=MsoNormalTable style="BACKGROUND: white" cellPadding=0 
bgColor=white border=0>
  <TBODY>
  <TR>
    <TD 
    style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP:
0.75pt">
      <P class=MsoNormal><FONT face="Times New Roman" color=black size=3><SPAN

      style="FONT-SIZE: 12pt; COLOR: black"><BR>_&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;_&nbsp;_&nbsp;_&nbsp;_<BR><BR>Information&nbsp;transmitted&nbsp;by&nbsp;this&nbsp;EMAIL&nbsp;is&nbsp;proprietary&nbsp;to&nbsp;iGATE&nbsp;Group&nbsp;of&nbsp;Companies&nbsp;and&nbsp;is&nbsp;intended&nbsp;for&nbsp;use&nbsp;only&nbsp;by&nbsp;the&nbsp;individual&nbsp;

      <BR>or&nbsp;entity&nbsp;to&nbsp;whom&nbsp;it&nbsp;is&nbsp;addressed&nbsp;and&nbsp;may&nbsp;contain&nbsp;information&nbsp;that&nbsp;is&nbsp;privileged,&nbsp;confidential,&nbsp;or&nbsp;exempt&nbsp;from&nbsp;disclosure&nbsp;under&nbsp;<BR>applicable&nbsp;law.&nbsp;If&nbsp;you&nbsp;are&nbsp;not&nbsp;the&nbsp;intended&nbsp;recipient&nbsp;of&nbsp;this&nbsp;EMAIL&nbsp;immediately&nbsp;notify&nbsp;the&nbsp;sender&nbsp;at&nbsp;iGATE&nbsp;or&nbsp;

      <A href="mailto:mailadmin@igate.com" 
      target=_blank>mailadmin@igate.com</A>&nbsp;<BR>and&nbsp;delete&nbsp;this&nbsp;EMAIL&nbsp;including&nbsp;any&nbsp;attachments<BR>_&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;_&nbsp;_&nbsp;_&nbsp;_

      <o:p></o:p></SPAN></FONT></P></TD></TR></TBODY></TABLE></DIV></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN 
style="FONT-SIZE: 12pt"><o:p>&nbsp;</o:p></SPAN></FONT></P></DIV><BR><BR>
<TABLE style="COLOR: black" bgColor=white>
  <TBODY>
  <TR>
    <TD><BR>_&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;_&nbsp;_&nbsp;_&nbsp;_<BR><BR>Information&nbsp;transmitted&nbsp;by&nbsp;this&nbsp;EMAIL&nbsp;is&nbsp;proprietary&nbsp;to&nbsp;iGATE&nbsp;Group&nbsp;of&nbsp;Companies&nbsp;and&nbsp;is&nbsp;intended&nbsp;for&nbsp;use&nbsp;only&nbsp;by&nbsp;the&nbsp;individual&nbsp;<BR>or&nbsp;entity&nbsp;to&nbsp;whom&nbsp;it&nbsp;is&nbsp;addressed&nbsp;and&nbsp;may&nbsp;contain&nbsp;information&nbsp;that&nbsp;is&nbsp;privileged,&nbsp;confidential,&nbsp;or&nbsp;exempt&nbsp;from&nbsp;disclosure&nbsp;under&nbsp;<BR>applicable&nbsp;law.&nbsp;If&nbsp;you!
 &nbsp;are&nbsp;not&nbsp;the&nbsp;intended&nbsp;recipient&nbsp;of&nbsp;this&nbsp;EMAIL&nbsp;immediately&nbsp;notify&nbsp;the&nbsp;sender&nbsp;at&nbsp;iGATE&nbsp;or&nbsp;mailadmin@igate.com&nbsp;<BR>and&nbsp;delete&nbsp;this&nbsp;EMAIL&nbsp;including&nbsp;any&nbsp;attachments<BR>_&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;_&nbsp;_&nbsp;_&nbsp;_</TD></TR></TBODY></TABLE></BODY></HTML>


Mime
View raw message