Solved

XML Classic ASP CDATA

Posted on 2013-11-08
1
766 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

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 …
Many times as a report developer I've been asked to display normalized data such as three rows with values Jack, Joe, and Bob as a single comma-separated string such as 'Jack, Joe, Bob', and vice versa.  Here's how to do it. 
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

770 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