<HTML xmlns:eXclaimer="http://www.exclaimer.co.uk">
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=UTF-16">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-16">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6603.0">
<TITLE>Adding elements after ResultsetBuilder class </TITLE>
</HEAD><BODY ><DIV>
<!-- Converted from text/rtf format -->
<BR>
<P> <FONT SIZE=2 FACE="Arial">Hi Folks,</FONT>
</P>
<P> <FONT SIZE=2 FACE="Courier New">Is there anyway of adding extra elements after fetching rows from a table and using ResultsetBuilder class.</FONT>
</P>
<P> <FONT SIZE=2 FACE="Courier New">The idea is that we have the xml like below...where a,b,c,d&e are all in one table and a1,a2 are in another table.</FONT></P>
<P>
<BR> <FONT SIZE=2 FACE="Courier New">Row one from table one...</FONT>
<BR> <FONT SIZE=2 FACE="Courier New"><a> 1 <a/></FONT>
<BR> <FONT SIZE=2 FACE="Courier New"><a1> xxx <a1/> row 1 from table 2, first col.</FONT>
<BR> <FONT SIZE=2 FACE="Courier New"><a2> yyy <a2/> row 1 from table 2, 2nd col. </FONT>
<BR> <FONT SIZE=2 FACE="Courier New"><b> 21 <a/></FONT>
<BR> <FONT SIZE=2 FACE="Courier New"><c> 31 <a/></FONT>
<BR> <FONT SIZE=2 FACE="Courier New"><d> 41 <a/></FONT>
<BR> <FONT SIZE=2 FACE="Courier New"><e> 51 <a/> End of row one from table one..</FONT>
</P>
<P> <FONT SIZE=2 FACE="Courier New">So when you fetch data from one table, you need to add elements/values from 2nd table after each row of table1.</FONT>
</P>
<P> <FONT SIZE=2 FACE="Courier New">Is this possible to do with JDOM? A working code would be useful.</FONT>
</P>
<P> <FONT SIZE=2 FACE="Courier New">rgds,</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">Rajesh Anand</FONT>
<BR><FONT SIZE=2 FACE="Courier New">Email:Rajesh_anand@ml.com</FONT>
</P>
<BR>
<BR>
</DIV>
<DIV>
<HR COLOR="gray">
</DIV>
<DIV>If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. <A HREF="http://www.ml.com/email_terms/">Click here </A>for important additional terms relating to this e-mail. <A HREF="http://www.ml.com/email_terms/">http://www.ml.com/email_terms/</A></DIV>
<DIV>
<HR COLOR="gray">
</DIV></BODY></HTML>