Subject: Re: database and XSL
From: a kusa <akusa8@xxxxxxxxx>
Date: Mon, 7 Dec 2009 12:47:00 -0600
|
Thank you Florent. Can you please point me to some examples where I
can see how this is implemented?
On Mon, Dec 7, 2009 at 9:39 AM, Florent Georges <lists@xxxxxxxxxxxx> wrote:
> a kusa wrote:
>
> Hi,
>
>> I have a requirement to be able to read from a data base and
>> map the data to an xml file.
>
>> Is it possible to write sql statements in XSLT 2.0? My google
>> did not give me good result set.
>
> Not in a standard way, but you can write your own extensions,
> or use existing one. Saxon for instance comes with such an
> extension (not sure it is in 9.2 HE, but normally it is in 9.1
> B).
>
> But when I have such a requirement (well, that's a bit short as
> requirement, but usually this is the right way) I define a
> document type, write a class that implements XMLReader, and use
> this class as the reader for the source of the transform.
>
> Either you create some objects from SQL, and pass them to the
> reader's ctor, or you eval the SQL statements directly within the
> reader.
>
> Regards,
>
> --
> Florent Georges
> http://www.fgeorges.org/
|