Hello,
I am new to xsl and am having a tough time with a template to transform the
results of an oracle "connect by" query into a hierarchical xml document.
The xml results of a sample query is below:
<page>
<rowset>
<row>
<site_id>1</site_id>
<site_name>Test Parent1</site_name>
<site_parent>0</site_parent>
<level>1</level>
<path>/0</path>
</row>
<row>
<site_id>2</site_id>
<site_name>Test Child1 of Test Parent1</site_name>
<site_parent>1</site_parent>
<level>2</level>
<path>/0/1</path>
</row>
<row>
<site_id>4</site_id>
<site_name>Test Child1 of Test Child1</site_name>
<site_parent>2</site_parent>
<level>3</level>
<path>/0/1/2</path>
</row>
<row>
<site_id>3</site_id>
<site_name>Test Parent2</site_name>
<site_parent>0</site_parent>
<level>1</level>
<path>/0</path>
</row>
</rowset>
</page>
where the site_parent value is the site_id of it's parent and a site_parent
of 0 is a top-level node.
I would like to produce a hierarchical xml doc based upon these results of
the form
<site>
<site_id>1</site_id>
<site_name>Test Parent1</site_name>
<site>
<site_id>2</site_id>
<site_name> Test Child1 of Test Parent1</site_name>
<site>
<site_id>4</site_id>
<site_name>Test Child2 of Test Child1</site_name>
</site>
</site>
</site>
<site>
<site_id>3</site>
<site_name>Test Parent2</site_name>
</site>
Has anyone had experience with this type of transform? Any help would be
appreciated.
Thanks in advance
todd
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list