[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] SQL BTree to XML Tree?
Hi all
I'm storing a btree in sql in the following manner: +----------------------------+ | Table: Departments | +----------------------------+ | id | name | lh | rh | +----------------------------+ | 1 | Managers | 1 | 6 | | 2 | Supervisors | 2 | 5 | | 3 | Employees | 3 | 4 | | 4 | Directors | 7 | 8 | +----------------------------+ This is being converted to xml, resulting in: <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> Any idea how I can do this? Thanks Phill
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|