DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=28681>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=28681 [PATCH] Xml output for the SQL task ------- Additional Comments From [EMAIL PROTECTED] 2004-05-05 15:40 ------- > To me, we should just map ResultSet object into XML. > ResultSets are an iterative version of a table, and we should just > be able to express that in XML. This seems quite similar to a resultset in xml to me: <sqlresults> <row><cell header="A">one</cell><cell header="B">1</cell></row> <row><cell header="A">two</cell><cell header="B">2</cell></row> <row><cell header="A">one</cell><cell header="B">11</cell></row> </sqlresults> > I do not understand why we need to do grouping here, Then tell me how you would do it instead. > and how do you > know the grouping is on "A" on your example. Are you parsing the SQL > or is this available as metadata from the resultset. It's the first column name, I get it from the metadata (@see the code). > I do not like all this nested things to be assummed just be the position of > the column or something some heuristic that will not work for the next guy > that tries to use the feature. The nesting follows the column numbers. A nesting level of 1 groups by the first column. It seems easy enough to understand, as it's what Excel or any other spreadsheet does when you ask for grouping. How would you do it instead? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
