RE: [xsl] Importing from database

Subject: RE: [xsl] Importing from database
From: "Chris Bayes" <Chris@xxxxxxxxxxx>
Date: Wed, 27 Jun 2001 11:23:54 +0100
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.

Ciao Chris

XML/XSL Portal
http://www.bayes.co.uk/xml


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread