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>
- Subject: RE: [xsl] Importing from database
- From: "Chris Bayes" <Chris at Bayes dot co dot uk>
- Date: Wed, 27 Jun 2001 11:23:54 +0100
- Reply-To: xsl-list at lists dot mulberrytech dot com
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