This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
RE: Importing from database
- To: "xsl-list at lists dot mulberrytech dot com" <xsl-list at lists dot mulberrytech dot com>
- Subject: RE: [xsl] Importing from database
- From: Matt Sergeant <matt at sergeant dot org>
- Date: Wed, 27 Jun 2001 02:38:50 +0100 (BST)
- Reply-To: xsl-list at lists dot mulberrytech dot com
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