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 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Antoines AntoinesSubject: How database to XML mapper can help me ?
Author: Antoines Antoines
Date: 16 May 2005 01:09 PM
Hi all,
I have a functionnal question. Please to tell me how StylusStudio can help me.

I have got a Web based application (Microsoft) which retrieves data from different Microsoft SQL database. Currently, new data extract into this application needs new developments in this application.
Now I want to provide to designer user ability to design its own XML data from database and integrate this design in my application. Then a operator user can call this design in my application to retrieve data with designed format.
As far I can see database to XML mapper or converter works with StylusStudio suite and not outside.

Please to tell me components to use in order to solve my problem.

Thanks

Posttop
Ivan PedruzziSubject: How database to XML mapper can help me ?
Author: Ivan Pedruzzi
Date: 18 May 2005 03:24 AM
Hi Antoines,

One way to let your users define an XML represenations for tables/views is SQLXML.

SQLXML has an intuitive syntax to bing the XML data model to table/columns

The following example shows one of the possible XML view for the Authors table

SELECT
XMLELEMENT(name "authors",
XMLELEMENT(name "au_id",t.au_id),
XMLELEMENT(name "au_lname",t.au_lname),
XMLELEMENT(name "au_fname",t.au_fname),
XMLELEMENT(name "phone",t.phone),
XMLELEMENT(name "address",t.address),
XMLELEMENT(name "city",t.city),
XMLELEMENT(name "state",t.state),
XMLELEMENT(name "zip",t.zip),
XMLELEMENT(name "contract",t.contract)
)
FROM pubs.dbo.authors t

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 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.