i would like to store the value in Vector either this way [[header1,header2,header3],[rs1,rs2,rs3]] OR [[header1,rs1,rs4][header2,rs2,rs5]]
my code is as follow
my desired xml format is <header1> <content>rs1</content> <content>rs4</content> </header1> <header2> <content>rs2</content> <content>rs5</content> </header2> <header3> <content>rs3</content> <content>rs6</content> </header3>
[ July 05, 2006: Message edited by: fang eve ] [ July 05, 2006: Message edited by: fang eve ]
Generating XML isn't very different from genertaing HTML, which you seem to have implemented already. The XML format you're looking for is column-oriented, not row-oriented like the code you posted, so you need to adapt your iteration logic to that.
I don't understand what you're trying to do with the database, or what storing values in a Vector has to do with generating XML.