Hi, we can't seem to make a transformation work when retrieving the data from a SQL source. We do get the XML back correctly, but when it's displayed as PDF, everything is blank. Perhaps there's something that we're missing w/r/t the way the namespaces are followed inside cocoon, but below is our sitemap.xmap, the xml before the transform and the XSL. Any help would be greatly appreciated. Thanks.
we've got the following URL from our site: http://whatever/reports/exhibitReport.pdf?id=45 in our sitemap.xmap file: ---------------- <map:match pattern="exhibitReport/*.pdf"> <map:generate type="request"/> <map:transform type="xslt" src="render-logic.xsl"> <map:parameter name="label" value="{1}"/> </map:transform> <map:transform type="xinclude"/> <map:transform type="xslt" src="render-logic.xsl"/> <map:transform type="sql"> <map:parameter name="dburl" value="jdbc:mysql://localhost/agilis?user=one&password=123abc" /> </map:transform> <map:transform src="exhibitSp.xsl"/> <map:serialize type="fo2pdf"/> </map:match> -------------- and in the exhibitSp.xsl (it's been trimmed down to only include relevant stuff) -------------- <?xml version="1.0" encoding="iso-8859-1"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; version="1.0" xmlns:fo="http://www.w3.org/1999/XSL/Format"; xmlns:mops="http://mops.cappsdigital.com/Report"; xmlns:sql="http://apache.org/cocoon/SQL/2.0"; > <!-- generate PDF page structure --> <xsl:template match="/"> <fo:root xmlns:fo="http://www.w3.org/1999/XSL/Format";> <fo:page-sequence master-reference="all"> <fo:flow flow-name="xsl-region-body"> <fo:table width="9in" padding="5pt" table-layout="fixed"> <fo:table-row> <fo:table-cell padding-before="4pt" padding-after="3pt" padding-right="5pt"> <fo:block font-family="Helvetica,Arial" font-size="8pt" text-align="left"> RSID </fo:block> </fo:table-cell> <fo:table-cell padding-before="4pt" padding-after="3pt" padding-right="5pt"> <fo:block border-style="solid" border-width="1pt"> <xsl:value-of select="/mops:report-sql/mops:data-blocks/mops:data-block/rowset/row/rsid"/> </fo:block> </fo:table-cell> .... thanks again.... Paul __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
