[thelist] XML help please

cspruck at mindspring.com cspruck at mindspring.com
Wed Jun 5 19:02:01 CDT 2002


On Thu, 06 Jun 2002 10:53:55 +1200 Duncan O'Neill <dbaxo at ihug.co.nz> wrote:
**************************************************
Hi all,

I have a problem with an XML dataset which I've
converted from an Access database using ASP.

The problem is that one of the fields (now an XML element) contains HTML markup. I've tried both converting the field into XML both 'raw' (i.e. within a normal element ) and as CDATA within that element. Either way, when I try to transform the XML on the server using XSL & ASP, it comes out with markup as literals ( i.e. <p> Blah Blah</p><p>yadda </p> etc).

Short of removing the HTML markup from the 26
original tables, or removing it by hand from the
XML, can someone please suggest a way to get
the HTML markup to function as such? I know I
can do it using ASP's response.write, but it
seems there should be an easier solution.
**************************************************

Duncan,

This may be more than you want to deal with, but you could add the HTML tags to your schema and validate the HTML tags as XML, then do the transform. I'm doing that on a project now. This, of course, is only good if you don't have to do tremendous amounts of clean-up in the HTML (also doing on a project now, hehe). Can you post a more detailed description or sample of how you're doing the transform? I couldn't tell if you're doing it with the raw data and just ASP somehow or if you're using an XSLT file in between.

HTH!

Chris



More information about the thelist mailing list