RE: [xsl] Importing from database

[Matt Sergeant <matt@xxxxxxxxxxxx>]

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