Hello
has someone tried to generate a PDF from an XSP
wich is filled by DatabaseRequest?
I tried it, but the result won't come up in my
Browserwindow!! Only the static Data like <title>
will be shown.
I tried to pipe the Request through the sitemap
like this:
<map:match pattern="view-pdf/*">
<map:generate src="docs/myown/ifx/{1}"/>
<map:transform
src="stylesheets/myown/dctv2pdf.xsl"/>
<map:serialize type="fo2pdf"/>
</map:match>
The Stylesheet and the xsp will be attached.
It would be great if someone could point me in the
right direction.
BTW: If I call the xsp via this for HTML it works:
<map:match pattern="ifx/*">
<map:generate type="serverpages"
src="docs/myown/ifx/{1}.xsp"/>
<map:transform
src="stylesheets/myown/default.html.xsl">
</map:transform>
<map:serialize/>
</map:match>
What am I doing wrong??
daniel
=====
--------------------------------------------------------
Daniel Pfuhl
mailto:[EMAIL PROTECTED]
__________________________________________________________________
Do You Yahoo!?
Gesendet von Yahoo! Mail - http://mail.yahoo.de
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsp:page
language="java"
xmlns:xsp="http://apache.org/xsp";
xmlns:esql="http://apache.org/cocoon/SQL/v2";
xmlns:xsp-request="http://apache.org/xsp/request/2.0";
>
<page>
<title>C2-DCTV</title>
<start><xsp-request:get-parameter name="startDate" default="Not provided"/></start>
<stop><xsp-request:get-parameter name="endDate" default="Not provided"/></stop>
<esql:connection>
<esql:driver>com.informix.jdbc.IfxDriver</esql:driver>
<esql:dburl>jdbc:informix-sqli://xxx.xxx.xxx.xxx:xxxx/media360:INFORMIXSERVER=media360_tcp</esql:dburl>
<esql:username>user</esql:username>
<esql:password>PW</esql:password>
<esql:execute-query>
<esql:query>SELECT assetid, id, vdate, topic, duration, bitrate, filename FROM dctv_videos_base WHERE vdate BETWEEN '<xsp-request:get-parameter name="startDate" default="null"/>' AND '<xsp-request:get-parameter name="endDate" default="null"/>'</esql:query>
<esql:results>
<esql:row-results>
<content>
<assetid><esql:get-string column="assetid"/></assetid>
<id><esql:get-string column="id"/></id>
<vdate><esql:get-string column="vdate"/></vdate>
<topic><esql:get-string column="topic"/></topic>
<duration><esql:get-string column="duration"/></duration>
<bitrate><esql:get-string column="bitrate"/></bitrate>
<filename><esql:get-string column="filename"/></filename>
</content>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
</page>
</xsp:page>
<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:fo="http://www.w3.org/1999/XSL/Format";>
<xsl:template match="/">
<fo:root xmlns:fo="http://www.w3.org/1999/XSL/Format";>
<fo:layout-master-set>
<fo:simple-page-master master-name="page"
page-height="29.7cm"
page-width="21cm"
margin-top="1cm"
margin-bottom="2cm"
margin-left="2.5cm"
margin-right="2.5cm">
<fo:region-before extent="3cm"/>
<fo:region-body margin-top="3cm"/>
<fo:region-after extent="1.5cm"/>
</fo:simple-page-master>
<fo:page-sequence-master master-name="all">
<fo:repeatable-page-master-alternatives>
<fo:conditional-page-master-reference master-name="page" page-position="first"/>
</fo:repeatable-page-master-alternatives>
</fo:page-sequence-master>
</fo:layout-master-set>
<fo:page-sequence master-name="all">
<fo:static-content flow-name="xsl-region-after">
<fo:block text-align="center"
font-size="10pt"
font-family="serif"
line-height="14pt">Seite <fo:page-number/></fo:block>
</fo:static-content>
<fo:flow flow-name="xsl-region-body">
<xsl:apply-templates/>
</fo:flow>
</fo:page-sequence>
</fo:root>
</xsl:template>
<xsl:template match="page">
<fo:block font-size="10pt" space-before.optimum="28pt" text-align="center"><xsl:value-of select="title"/></fo:block>
<fo:block>hier content<xsl:apply-templates select="content"/></fo:block>
</xsl:template>
<xsl:template match="content">
<fo:block font-size="12pt" space-before.optimum="12pt" text-align="center">nun die ID<xsl:apply-templates select="id"/></fo:block>
</xsl:template>
<xsl:template match="id">
<xsl:apply-templates/>
</xsl:template>
</xsl:stylesheet>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
