Here's what im trying to do:
(I want to see if anyone has advice/changes/or have done this before)
I have a cms system that is built on asp and an access database..to add/edit/delete articles. I would also like to create these articles as xml.
Currently i am inputing the data from a form into a database, and also creating a seperate xml file using FSO.
My design questions are should I, instead input all the data into the database as xml...then when retrieving the data transform it with xsl/asp?
Any other comments on this project .. has anybody done something similiar?
One of the current problems is if if someone tags html into one of the fields for the input...that works fine with the database, but the resulting xml document also has these tags in it, but I want the xml document clean with no presentation tags.