Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

XML Classic ASP CDATA

Posted on 2013-11-08
1
Medium Priority
?
826 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 60

Accepted Solution

by:
Geert Bormans earned 2000 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

PowerShell Core for Advanced Linux Administrators

Understand advanced principals around Powershell Core with a focus on the Linux Administrator.  This course covers how to administer numerous environments across multiple platforms including Linux, Azure, AWS, and Google Cloud from a single shell instance.

Question has a verified solution.

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

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 …
Create a Windows 10 custom Image with custom task bar and custom start menu using XML for deployment.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

722 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