Solved

XML Classic ASP CDATA

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

Monthly Recap

May was a big month for new releases from Linux Academy! Take a look at what our team built recently in our blog. You can access the newest releases from our blog.

Question has a verified solution.

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

The Client Need Led Us to RSS I recently had an investment company ask me how they might notify their constituents about their newsworthy publications.  Probably you would think "Facebook" or "Twitter" but this is an interesting client.  Their cons…
Create a Windows 10 custom Image with custom task bar and custom start menu using XML for deployment.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

626 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