XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » Convert data from SQL database to a XML-file based on a DTD
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + Report editor automatic scroll... (2)
-> + java.lang.ClassNotFoundExcepti... (4)
-> + Strange output (6)
-> + Built-In Processor Handling CD... (5)
-> + Parameter values with multiple... (3)
-> + Schema review (2)
-> + seperating values within one e... (2)
-> + Filtering 1000's of XML files ... (2)
-> + replace fop0.20 by 094 (2)
-> + HTML tables from sorted XSL (3)
-> + From dicisionshema to XML (4)
-> - Convert data from SQL database... (2)
-> ->Convert data from SQL dat...
-> + Really Really need help - xsl:... (2)
-> + xslt: xsl:include not finding ... (2)
-> + One field in multiple lines (3)
-> + Stylis studio editor slow (2)
-> + Schema Documentation (3)
-> + Convert PCL to XML (7)
-> + crashing when connected via VP... (3)
-> + Repeater err:XPST0003 (3)
-- Previous [1321-1340] [1341-1360] [1361-1380] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
mackan mackanSubject: Convert data from SQL database to a XML-file based on a DTD
Author: mackan mackan
Date: 27 Nov 2007 08:56 AM
Hi,

Hope someone can help me.

The task.
I have a table in a SQL database with data which I want to extract into a
XML-file. I want the XML-file to follow a specific DTD which I also have.
How can I associate a specific column in the database to a specific element in the DTD?
For exampel:
I have three columns in man database table. ID, NAME and NUMBER.
I have a DTD which look like this (part of it)
<!ATTLIST allocation
ID CDATA #REQUIRED
NAME CDATA #REQUIRED
NUMBER CDATA #REQUIRED
>

How do I connect the database column ID with the ID in the DTD and then build a XML-file of it?

Regards
Markus
Posttop
Ivan PedruzziSubject: Convert data from SQL database to a XML-file based on a DTD
Author: Ivan Pedruzzi
Date: 27 Nov 2007 10:53 AM

Hi Markus,

Please take a look to the video tutorial at
http://www.xquery.com/videos/datadirectxquery/ddxq1a.html


Hope this helps
Ivan Pedruzzi
Stylus Studio Team
   
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.