|
[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] 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
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|

Cart








