Calling SQLXML From XSLT

(Sorry for the cross-post - I put this on the regular XML list by
accident.)
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
Check out this article:
Communicate with a SQL Database During an XSL Transform
http://www.braintrove.com/article/30
Greg Collins [Microsoft MVP]
Visit Braintrove ( http://www.braintrove.com )
|||On Apr 26, 11:34 am, "Greg Collins [Microsoft MVP]"
<gcollins_AT_msn_DOT_com> wrote:
> Check out this article:
> Communicate with a SQL Database During an XSL Transformhttp://www.braintrove.com/article/30
> --
> Greg Collins [Microsoft MVP]
> Visit Braintrove (http://www.braintrove.com)
This a good article, Greg. However, I'm trying to accomplish this
strictly with SQLXML via 1 URL. I pass the master xml doc along with
an xslt doc which itself creates a variable via another SQLXML URL.
Any more ideas about this?
Thanks!

Calling SQLXML From XSLT

(Sorry for the cross-post - I put this on the regular XML list by
accident.)
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.aspxCheck out this article:
Communicate with a SQL Database During an XSL Transform
http://www.braintrove.com/article/30
--=20
Greg Collins [Microsoft MVP]
Visit Braintrove ( http://www.braintrove.com )|||On Apr 26, 11:34 am, "Greg Collins [Microsoft MVP]"
<gcollins_AT_msn_DOT_com> wrote:
> Check out this article:
> Communicate with a SQL Database During an XSL Transformhttp://www.braintro
ve.com/article/30
> --
> Greg Collins [Microsoft MVP]
> Visit Braintrove (http://www.braintrove.com)
This a good article, Greg. However, I'm trying to accomplish this
strictly with SQLXML via 1 URL. I pass the master xml doc along with
an xslt doc which itself creates a variable via another SQLXML URL.
Any more ideas about this?
Thanks!