in reply to SQL->XML->XSLT

Maybe the XML::Generator::DBI Tutorial might be of help to you. Check out parts 4 and 5.

jeffa

L-LL-L--L-LL-L--L-LL-L--
-R--R-RR-R--R-RR-R--R-RR
B--B--B--B--B--B--B--B--
H---H---H---H---H---H---
(the triplet paradiddle with high-hat)

Replies are listed 'Best First'.
Re: (jeffa) Re: SQL->XML->XSLT
by set_uk (Pilgrim) on Apr 08, 2003 at 13:01 UTC
    Thanks for this - Tried it and it worked and pretty much did what I want. However (and isn't there always a however). I want to be able to pass in a variable to the XSLT transormation that isn't part of the query (the report title). And here is where I am going up the Perl Object learning curve.

    I can see that XML::Filter::XSLT uses XML::Filter::XSLT::LibXSLT and that this uses XML::LibXSLT to parse the stylesheet.

    I can also see that XML::LibXSLT supports transform(doc, %params) to allow me to pass in hash of parameters to the transformation. Which I have tested - and the value of the variable is replaced in the transformation using <xsl:value-of select="$cust_name"/>

    It doesn't appear there is anyway that I can pass in a hash to the XML::Filter::XSLT as described in the example as there is no method - or is there.

    Any pointers you can give
      There is not. Patches welcome, or post a bug report on RT.