Hi,<br /><br />I created a simple process that executes a SQL query and transforms the data to XML. I've put that variable as an output parameter to see the result.<br /><br />Unfortunately, LCES makes a document element from it with CDATA in it. This is not what I want. I want the nodes to appear directly in my output.<br /><br />Anybody who knows what I should do ?<br /><br />Regards<br />Yves<br /><br /><soapenv:Body><br /> <invokeResponse xmlns="http://adobe.com/idp/services"><br /> <test_data xsi:type="ns1:XML" xmlns:ns1="http://adobe.com/idp/services"><br /> <document><?xml version="1.0"?><br /><xml><row><EventDate type="DATE">2006-02-16</EventDate><Jobs type="INTEGER UNSIGNED">9</Jobs><Pages type="INTEGER UNSIGNED">9</Pages><FirstJob type="TIME">14:06:51</FirstJob><LastJob type="TIME">15:42:32</LastJob></row><row><EventDate type="DATE">2006-02-17</EventDate><Jobs type="INTEGER UNSIGNED">22</Jobs><Pages type="INTEGER UNSIGNED">22</Pages><FirstJob type="TIME">13:13:17</FirstJob><LastJob type="TIME">15:23:00</LastJob></row>
Hmm, I can't post an example ... unless i split the CDATA<br /><br /><test_data xsi:type="ns1:XML" xmlns:ns1="http://adobe.com/idp/services"><br /> <document><![CD A T A[<?xml version="1.0"?><br /><xml><row><EventDate type="DATE">2006-02-16</EventDate><Jobs type="INTEGER UNSIGNED">9</Jobs><Pages type="INTEGER UNSIGNED">9</Pages><FirstJob type="TIME">14:06:51</FirstJob><LastJob type="TIME">15:42:32</LastJob></row>
When one XML document (e.g. a SOAP response) contains a separate XML document within it, that XML data is wrapped in a CDATA tag. One way to get around this is to use the XSLT Service to produce a new XML document containing only the contents of the CDATA. I attach a sample process xml and an xsl file that may be useful.
Thanks for the reply, but this does not solve my problem.
I want to do this in the workbench itself. With your code, I can create a new variable with the content in it, but still, when exported, it gives me the document tag again with the CDATA tags.