SSDN - Convert data from SQL database to a XML-file based on a DTD

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

mackan mackan

Subject: 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

Ivan Pedruzzi

Subject: 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

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.