This is the mail archive of the xsl-list@mulberrytech.com mailing list .


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]

RE: Importing from database


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


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]