Subject: RE: Importing from database
From: Matt Sergeant <matt@xxxxxxxxxxxx>
Date: Wed, 27 Jun 2001 02:38:50 +0100 (BST)
|
On Wed, 27 Jun 2001, Chris Bayes wrote:
> Ben,
>
> >XSLT does not allow for ODBC calls out... you have to pass in a tree
> >representation of a valid XML document, and process that according to
> >the XSLT.
>
> That isn't quite true but anyway the easiest way is something like
> <xsl:apply-templates
> select="document('http://localhost/Northwind?SQL=SELECT+firstname,lastname+F
> ROM+employees+FOR+XML+AUTO')" />
> if you have SQL 2000 or the SQL XML Technology preview.
Oooh, fun fun fun:
<xsl:apply-templates
select="document('http://server.com/Northwind?SQL=DELETE+FROM+employees')"/>
:-)
--
<Matt/>
/|| ** Founder and CTO ** ** http://axkit.com/ **
//|| ** AxKit.com Ltd ** ** XML Application Serving **
// || ** http://axkit.org ** ** XSLT, XPathScript, XSP **
// \\| // ** mod_perl news and resources: http://take23.org **
\\//
//\\
// \\
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|