XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
John PapadopoulosSubject: Relational Database Hierarchical (flat) table to XML Tree Mapping.
Author: John Papadopoulos
Date: 06 Jun 2007 01:44 PM
Hi,
I have a hierarchical table in a relational database. The table structure is:

id, description, parent_id.

How can I map it (create child elements) to an XML tree using Stylus Studio? Any screencasts?

Posttop
Minollo I.Subject: Relational Database Hierarchical (flat) table to XML Tree Mapping.
Author: Minollo I.
Date: 06 Jun 2007 02:13 PM
I guess what you want to do is to convert that table into a hierarchical XML; you should be able to do something like this (using the proper table information in XQuery):


declare function local:getChildren($node as element(*,xs:anyType))
{
for $child in collection("pubs.dbo.hierarchy")/hierarchy[number(parent_id) = number($node/id)]
return
<item id="{$child/id}">
<value>{$child/description/text()}</value>
{local:getChildren($child)}
</item>
};


<items> {
for $roots in collection("pubs.dbo.hierarchy")/hierarchy[not(parent_id)]
return
<item>
<value>{$roots/description/text()}</value>
{local:getChildren($roots)}
</item>
} </items>

 
Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.