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
PDF.
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.
Subject:xml RDBXML getting the data Author:TRACEY RAWLINGS Date:02 Jun 2005 07:15 AM
I have to hit the big green button to reload the data then it works...i cannot just execute the XSLT it returns old data..then when hit button to reload it does.