Subject: RE: [xsl] Carriage return in XML From: Pieter Reint Siegers Kort <pieter.siegers@xxxxxxxxxxx> Date: Wed, 9 Feb 2005 17:19:32 -0600 |
Hi Matthew, Actually this is not a XSLT question; I see you're using SQLXML, so to change your XML input source you'll need to change the way SQL returns the XML. There are different formats in which SQL can return XML, see the books online. The solution you read was about XSLT and that is outside your process. HTH, <prs/> -----Original Message----- From: Matthew Day [mailto:mday@xxxxxxxxx] Sent: Wednesday, February 09, 2005 4:34 PM To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx Subject: [xsl] Carriage return in XML 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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] Carriage return in XML, Brad Williams | Thread | RE: [xsl] Carriage return in XML, Matthew Day |
RE: [xsl] Carriage return in XML, Brad Williams | Date | RE: [xsl] Carriage return in XML, Matthew Day |
Month |