Hi
I am trying to generate a file of XML which is imported into a third
party App.
So Far I have an wsh script
var xml= new ActiveXObject("Msxml2.DomDocument.4.0");
xml.async = false;
xml.preserveWhiteSpace = true;
xml.load("http://localhost/routingtwo/template/test.xml");
xml.save("testoutput.xml");
XML template
<?xml version="1.0" encoding="UTF-8"?>
<csm xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<sql:query>
exec CSM.dbo.querystrCR
</sql:query>
</csm>
So the XML file is created by accessing SQL server over http and saved
locally. In a web browser the xml looks identical to an example xml file
which can be imported into the app. However the xml file I generate will
not import into the app, and I've narrowed the problem to a CR (carriage
return) problem. I can manually add them in and it does import
In WordPad my XML looks like
<csm>
<field1>value</field1><field2>value</field2>
</csm>
But is should be like
<csm>
<field1>value</field1>
<field2>value</field2>
</csm>
Using google I see some other people with this problem and a solution of
<xsl:text></xsl:text> However I'm not sure how to impliment this into my
process.
Any help appreciated.
Cheers
Matt
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--