Subject: [xsl] Flat DB structure into XML Hierarchy From: "Dave Quested" <dave.quested@xxxxxxxxx> Date: Mon, 29 Jan 2007 15:06:28 +0000 |
Hi there, pretty new to XSLT and wondered if anyone could point me in the right direction. I'm trying to take a flat db structure from a query and transform it into a hierarchical xml structure.
<data> <row> <section_depth>1</section_depth> <section_title>Home</section_title> </row> <row> <section_depth>2</section_depth> <section_title>Events</section_title> </row> <row> <section_depth>3</section_depth> <section_title>Event 1</section_title> </row> <row> <section_depth>3</section_depth> <section_title>Event 2</section_title> </row> <row> <section_depth>2</section_depth> <section_title>Equipment</section_title> </row> <row> <section_depth>2</section_depth> <section_title>News</section_title> </row> <row> <section_depth>3</section_depth> <section_title>News 1</section_title> </row> <row> <section_depth>3</section_depth> <section_title>News 2</section_title> </row> </data>
I'm looking to transform this with XSLT 2, into this using the section_depth as the indentation, can always assume the flat structure will be in the right order:
<site> <section> <title>Home</title> <section> <title>Events</title> <section> <title>Event 1</title> </section> <section> <title>Event 2</title> </section> </section> <section> <title>Equipment</title> </section> <section> <title>News</title> <section> <title>News 1</title> </section> <section> <title>News 2</title> </section> </section> </section>
I've played around with grouping but my head started to hurt. Thanks in advance for any help!
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] would like to simplify my, cknell | Thread | Re: [xsl] Flat DB structure into XM, David Carlisle |
RE: [xsl] would like to simplify my, cknell | Date | RE: [xsl] IDE, Chaudhary, Harsh |
Month |