Hi,
I want to display the values form jsp table like below
HITS 222 333 444 4555 55566 666 666 777 777 888 888
REISSUED 33 111 22 22 33 333 444 444 555 5666 666 777
ADDCOLL 000 00 0.0 90 000 8888 99999 777 666 666 555
CHANGEFEE 00 000 00 00 00 000 00 0 000 0 00 0 00000
The below code displays vertically, I want to display horizontally like above. How can I display like above output. Could you please help me in this case?
while(s[iC] != null) { sResult = ""; rs = wda.getStats(s[iC], quarter1, year1, quarter2, year2); rs.first(); if (rs.getRow() > 0) { sResult = sResult.concat( "<tr BGCOLOR=#99CCFF>"); sResult = sResult.concat( "<td valign= bottom><font size=";2">;" + "HITS" + "</font></td>" ); sResult = sResult.concat( "<tr> <td valign=bottom> <font size=";2">;" + "REISSUED" + "</font></td></tr>" ); sResult = sResult.concat( "<tr> <td valign= bottom> <font size=";2">;" + "ADD_COLL" + "</font></td></tr>" ); sResult = sResult.concat( "<tr> <td valign= bottom> <font size=";2">;" + "CHANGE_FEE"; + "</font></td></tr>" ); sResult = sResult.
concat( "<tr> <td valign= bottom> <font size=";2">;" + "AMT_PROCESSED" + "</font></td></tr>" ); sResult = sResult.concat( "<tr> <td valign= bottom><font size=";2">;" + "Est_AMT" + "</font></td></tr></tr>" ); do { sAmount1 = dfAmount1.format(rs.getInt(1)); sAmount2 = dfAmount1.format(rs.getInt(2)); sAmount3 =
dfAmount2.format(rs.getDouble(3)); sAmount4 = dfAmount2.format(rs.getDouble(4)); sAmount5 = dfAmount2.format(rs.getDouble(5)); sAmount6 = dfAmount2.format(rs.getDouble(6)); sResult = sResult.concat(";<td align= right>" + sAmount1 + "</td>"); sResult = sResult.concat(";<td align=right>"; + sAmount2 + "</td></tr>"); sResult = sResult.concat(";<td align=right>"; + sAmount3 + "</td></tr>"); sResult = sResult.concat(";<td align=right>"; + sAmount4 + "</td></tr>"); sResult = sResult.concat(";<td align=right>"; + sAmount5 + "</td></tr>"); sResult = sResult.concat(";<td align=right>"; + sAmount6 + "</td></tr>"); }while(rs.next());
sResultTable = "<table>" + sResultTable "<p><b><font color="#3366FF" size=";4">;" s[iC] + " " + "</font>" + "<br>"; "</b>"; "<table width=90% border=1 cellpadding=0 cellspacing=0 height=60>" + sResult + "</table>"; } //if (rs.getRow() > 0) iC++; } //while(s[iC] != null) } //try catch(Exception e) { out.println("<B> Unable
to retrieve data from database"); e.printStackTrace(); return; }
Can anyone help me please. It is reaaly very important
Thanks a lot
---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.
[Non-text portions of this message have been removed]
.