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
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Pranav GuptaSubject: Attribute Centeric XML from Relational Database
Author: Pranav Gupta
Date: 14 Apr 2008 02:13 AM
I have a relation database and i need to create an Attribute centeric XML file, Some one please guide me to do this.

Thanks

Posttop
Minollo I.Subject: Attribute Centeric XML from Relational Database
Author: Minollo I.
Date: 14 Apr 2008 10:44 AM
I'm not positive I understand what you are looking for; but if you are looking for a RDBMS table rendered as XML where columns are represented as attributes, you can easily do that using DataDirect XQuery in Stylus Studio; the following little XQuery will do that for the table named "booksXML".

<books> {
for $booksXML in collection("booksXML")/booksXML
return
<book> {
for $column in $booksXML/*
return
attribute {$column/name()} {$column/text()}
} </book>
} </books>

 
Topic Page 1 2 3 4 5 6 7 8 9 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.