You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Paul Tomsic <pt...@yahoo.com> on 2003/06/30 23:58:30 UTC

including a static XML file in the return from my sql call?

I'm trying to import a static XML file into the
results of my SQL call.  
Here's my sitemap.xmap block:
    	<map:match pattern="ameddReportByBDE/*.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="xinclude"/>

<map:transform type="xslt" src="render-logic5.xsl">	
<map:parameter name="label" value="{1}"/>
</map:transform>
<map:transform type="sql">
					<map:parameter name="dburl"
value="jdbc:mysql://localhost/amedd?user=admin&amp;password=alpha"
/>
				</map:transform>
<map:transform type="xinclude"/>			

<!--

				<map:transform src="ameddReportByBDE.xsl"/>

				<map:serialize type="fo2pdf"/>
-->
	    		<map:serialize type="xml"/>
    	</map:match>

and inside render-logic5.xsl, I've got :
	
<xsl:template match="mops:report-sql">
		<mops:report-xinclude-headlines>
			<xi:include>
				<xsl:attribute name="href">reports/<xsl:value-of
select="$label"/>/headlines.xml#xpointer(/headlines)</xsl:attribute>
			</xi:include>			
		</mops:report-xinclude-headlines>
	</xsl:template>

but my final XML only includes the "included" xml, and
not the results from the sql query.

Help?


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org


Re: including a static XML file in the return from my sql call?

Posted by Joerg Heinicke <jo...@gmx.de>.
Have a look on the output of the render-logic5.xsl transformation. You 
have maybe kicked the sql:* elements out of your XML.

Joerg

Paul Tomsic wrote:
> I'm trying to import a static XML file into the
> results of my SQL call.  
> Here's my sitemap.xmap block:
>     	<map:match pattern="ameddReportByBDE/*.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="xinclude"/>
> 
> <map:transform type="xslt" src="render-logic5.xsl">	
> <map:parameter name="label" value="{1}"/>
> </map:transform>
> <map:transform type="sql">
> 					<map:parameter name="dburl"
> value="jdbc:mysql://localhost/amedd?user=admin&amp;password=alpha"
> />
> 				</map:transform>
> <map:transform type="xinclude"/>			
> 
> <!--
> 
> 				<map:transform src="ameddReportByBDE.xsl"/>
> 
> 				<map:serialize type="fo2pdf"/>
> -->
> 	    		<map:serialize type="xml"/>
>     	</map:match>
> 
> and inside render-logic5.xsl, I've got :
> 	
> <xsl:template match="mops:report-sql">
> 		<mops:report-xinclude-headlines>
> 			<xi:include>
> 				<xsl:attribute name="href">reports/<xsl:value-of
> select="$label"/>/headlines.xml#xpointer(/headlines)</xsl:attribute>
> 			</xi:include>			
> 		</mops:report-xinclude-headlines>
> 	</xsl:template>
> 
> but my final XML only includes the "included" xml, and
> not the results from the sql query.
> 
> Help?


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org