[xsl] Carriage return in XML

["Matthew Day" <mday@xxxxxxxxx>]

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