Re: SQL BTree to XML Tree?

Phillip B Oldham wrote:

> <output>
>   <item>
>     <id>1</id>
>     <name>Managers</name>
>     <lh>1</lh>
>     <rh>2</rh>
>   </item>
> <!-- etc -->
> </output>

> I need to translate this using XSL to this:

> <group>
>   <department title="Managers">
>     <department title="Supervisors" />
>     <department title="Employees" />
>   </department>
>   <department title="Directors" />
> </group>

  You apply the template to your root 'item'.  In the 'item' template
rule, you apply template to "../item[id=current()/lh]" and then to
"../item[id=current()/rh]".

--drkm