How to extract data from database to XSLT?

[flowertang]

I want to generate a report by XSLT, but the data is extracted from the database. I will use Access/SQL server for my database. Can i write SQL in XSLT to extract data from database? Have any sample code or reference website to show how it work?
THX

 

[whichman]

XSLT is simply a text file that can be processed with an XSLT parser. It does not access the filesystem.
You have to extract the data, convert it to some XML format and transform it using an existing XSLT template.

Check DataML, at

http://dataml.net

it might help you
Build web applications faster with a few lines of XML Code using DataML[tm]

http://dataml.net

 

[bepepi]

hey,
i have done this with java servlets.
servlet connect database, read datas building DOMTree, write XML file from DOMTree,transform xml by xsl into html.
i can give you my code.
bepepi