Solved

XML Classic ASP CDATA

Posted on 2013-11-08
1
780 Views
Last Modified: 2013-11-08
I am working with a Finance software package that stores data in an XML blob.
I have used this capability to store a xml node and the software stores it within CDATA.

In an asp classic page I am retrieving the CDATA 'node' and trying to then load it using loadxml.  I get a parse error the srcText property has the CDATA in the header.

I do not have a way to re-create this on the internet, so I am trying to explain this best way possible and hope for suggestions, ideas, things to investigate.

So, my question is as follows based on the above
1.  How do I selectnodes to get into the CDATA, not with it.
2.  Other ideas, reasons why I would get a parse error when loading valid xml as a string retrieved from within the CDATA.
Note: when I manually copy the string and load it, it works find.  In a text document, there is no visible difference between the manual copy and the retrieved version.

Thanks,
0
Comment
Question by:KeithMcElroy
1 Comment
 
LVL 60

Accepted Solution

by:
Geert Bormans earned 500 total points
ID: 39633698
If the BLOB is really XML
(it is a real pain in the b.. that products actually do that)
then you could use a simple XSLT to "transform" just the CDATA section (which is a textnode)
and output the CDATA node as a string with disable-output-escaping="yes"
I am not sure the ASP serialiser doesn't break it, but it is worth a try
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The Problem How to write an Xquery that works like a SQL outer join, providing placeholders for absent data on the outer side?  I give a bit more background at the end. The situation expressed as relational data Let’s work through this.  I’ve …
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question