Subject: RE: [xsl] Importing from database From: "Ben Robb" <b.robb@xxxxxxxxxx> Date: Wed, 27 Jun 2001 10:51:14 +0100 |
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. There are lots of approaches for integrating with a SQL server: 1) The heavy duty approach - build COM objects to marshall the calls to the db, and return strings of well formed XML. 2) The lightweight approach - use ASP to build an XML string dynamically (either through a while not loop or by using ADO recordset's return as XML feature). 3) Use SQL-XML to build templates of XML, and use the MSXML3 SERVERXMLHTTP method to get the result. [assuming you are using SQL 2000, or SQL 7.0 with the extension]. All of these ways work, and there isn't much in it (SQL-XML is faster, but unless you are doing really complicated SQL calls, it is barely noticeable). Hope that helps, Ben > -----Original Message----- > From: Gustaf Liljegren [mailto:gustaf.liljegren@xxxxxx] > Sent: 27 June 2001 10:22 > To: XSL List > Subject: [xsl] Importing from database > > > Hello, > > I have some data in an MS SQL Server database that I'd like > to publish on > paper using XSL, so I wonder if there are any good rules for > how to achieve > this. I know about the export XML functionality in SQL > Server, but I figured > that maybe this step isn't necessary. As the data is filtered through > XSLT later, maybe there's a way to do the connection between > the database > and XSLT directly, perhaps with extensions? > > Regards, > > Gustaf Liljegren > > > > XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list > > XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] Importing from database, Rafael R. Sevilla | Thread | RE: [xsl] Importing from database, Chris Bayes |
Re: [xsl] pls help me on XML-XSLt T, Rafael R. Sevilla | Date | [xsl] A doubt on call-template rule, Satish_Komma |
Month |