Microsoft XML - Calling SQLXML In XSLT

Author

Calling SQLXML In XSLT

BradR

2007-04-20, 6:17 pm

There there anyway to get this to work:

http://mydomain.com/some.xml&xsl=mother.xslt

where some.xml is

<root xmlns:sql='urn:schemas-microsoft-com:xml-sql'>
<sql:header sql:nullvalue="IsNULL">
</sql:header>
<sql:query >
SELECT * FROM sometable
FOR XML path('somenode'), root('nodes')
</sql:query>
</root>

and mother.xslt has

<xsl:variable name="employees" select="document('http://mydomain.com/
someother.xml')"/>

Note that we use windows authentication.

Based on these, it appears not to be possible:
http://msdn2.microsoft.com/en-us/library/ms763800.aspx
http://msdn2.microsoft.com/en-us/library/ms256465.aspx

Joe Fawcett

2007-04-21, 6:15 am

As you state you don't seem to have much control over the creation of the
XslTransform used by SQLXML.
Perhaps you could replace mother.xslt by a dynamic page, asmx or aspx, that
actually constructs what you need and embeds
'http://mydomain.com/someother.xml'?

--

Joe Fawcett (MVP - XML)
http://joe.fawcett.name

"BradR" <bdrhoa@XXXXXXXXXX> wrote in message
news:1177088558.548875.142950@b58g2000hsg.googlegroups.com...
> There there anyway to get this to work:
>
> http://mydomain.com/some.xml&xsl=mother.xslt
>
> where some.xml is
>
> <root xmlns:sql='urn:schemas-microsoft-com:xml-sql'>
> <sql:header sql:nullvalue="IsNULL">
> </sql:header>
> <sql:query >
> SELECT * FROM sometable
> FOR XML path('somenode'), root('nodes')
> </sql:query>
> </root>
>
>
> and mother.xslt has
>
> <xsl:variable name="employees" select="document('http://mydomain.com/
> someother.xml')"/>
>
> Note that we use windows authentication.
>
> Based on these, it appears not to be possible:
> http://msdn2.microsoft.com/en-us/library/ms763800.aspx
> http://msdn2.microsoft.com/en-us/library/ms256465.aspx
>