I am using a SQL Server stored procedure with an XML template to generate an XML file. This is working fine. However, I need to transform the generated XML to XML (need to re-arrange the xml so it can be validated against our stars.xsd schema) and this is where I am having problems.
I have linked the XSL stylesheet to my XML document using the standard <?xml-stylesheet type="text/xml" href=http://www.webdeveloper.com/forum/archive/index.php/"case.xsl"?> and within my XSL I have included <xsl
utput method="xml" indent="yes" encoding="utf-8"/>. When I look at my XML document, its still in an untransformed state as if I had not even applied the XSL! No errors are generated, just left with XML that is not being transformed by the XSL stylesheet.
My code is attached in the Zip.
I would appreciate any help received!
TIA,
Frustrated SQL Chick
I have linked the XSL stylesheet to my XML document using the standard <?xml-stylesheet type="text/xml" href=http://www.webdeveloper.com/forum/archive/index.php/"case.xsl"?> and within my XSL I have included <xsl
utput method="xml" indent="yes" encoding="utf-8"/>. When I look at my XML document, its still in an untransformed state as if I had not even applied the XSL! No errors are generated, just left with XML that is not being transformed by the XSL stylesheet.My code is attached in the Zip.
I would appreciate any help received!
TIA,
Frustrated SQL Chick