Subject:Convert data from SQL database to a XML-file based on a DTD Author:mackan mackan Date:27 Nov 2007 08:56 AM
Hope someone can help me.
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?
I have three columns in man database table. ID, NAME and NUMBER.
I have a DTD which look like this (part of it)
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?