Subject: RE: [xsl] Importing from database From: Matt Sergeant <matt@xxxxxxxxxxxx> Date: Wed, 27 Jun 2001 02:38:50 +0100 (BST) |
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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] Importing from database, Chris Bayes | Thread | RE: [xsl] Importing from database, Ben Robb |
RE: [xsl] Non-hierarchy XML -> hier, Paul R Brown | Date | RE: [xsl] How do I keep the text se, Jarno Elovirta |
Month |