Subject:xml RDBXML getting the data Author:Tony Lavinio Date:31 May 2005 11:44 PM
You don't have to explicitly save the XML output by your SQL/XML to a
file in order to run the XSLT to produce the FO that creates the labels
1. Creating the SQL/XML query and save it in the special DB filesystem.
2. Create a new XSLT transform, and for the input, choose the DB
filesystem, and choose the SQL/XML you saved in step 1.
3. On the post-process tab, set Apache FOP as the outputter.
4. Now, create your XSLT that produces XSL FO.
Each time you run the XSLT, you will pull fresh data from your database
and it will be piped directly through your XSLT into the PDF.