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

[hoocken]

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
hoocken

 

[tsuji]

While I would welcome this question posed to this forum, at this point of time, I would suggest that op may try in parallel the sql-dedicated forum(s) where more specialists hang out there.

http://tek-tips.com/threadminder.cfm?pid=183