RE: Multiple .xsp?

>    <xsl:processing-instruction
name="cocoon-process">type="xsp"</xsl:processing-instruction>
>    <xsl:processing-instruction
name="cocoon-process">type="xsp"</xsl:processing-instruction>
>    <xsl:processing-instruction
name="xml-logicsheet">href="test-sql2.xsl"
type="text/xsl"</xsl:processing-instruction>

I don't know why you are generating two XSP PIs, but you should create
PIs that are the same as your source page. That is if you have an XSP
page with Cocoon PIs for XSP, Cocoon will process the XSP. If the
resulting output in turn has similar PIs Cocoon will process it aswell.
I have only some experience with XSP, but I have done this with XSL to
chain transformations.


> -----Original Message-----
> From:	Matt Sabourin [SMTP:Matt.Sabourin@xxxxxxxx]
> Sent:	Monday, June 18, 2001 9:42 PM
> To:	XSL List
> Subject:	 Multiple .xsp?
> 
> 
> 
> I am trying to create a ( what I thought was fairly simple ) database
> access using Cocoon 1.8.2 and XSP.  My database contains multiple
> tables
> holding employee information, phone numbers, pager numbers, etc.  At
> the moment, all I'm trying to do is create a table listing the
> employee
> entries, along with their associated data ( pager, phone, etc ).
> 
> My problem occurs when I try to pull the data out of the DB.  I can
> get the rows out using one query in my XSP.  Unfortunately, I can't
> seem to use the information pulled from that query in a separate
> template
> ( in the same file ), to run a second query.  I could probably nest
> the queries, but I *really* want to avoid that ( harder to read, not
> as reusable, etc ).
> 
> My second attempt was to pull all the employee rows out of the
> database,
> then send that information to a second XSP.  Unfortunately, I can not
> seem to make Cocoon process/compile that second sheet consistently. 
> Sometimes it recompiles, sometimes it doesn't.  I have tried every
> combination of pi's that I could think of.  Currently, I have this in
> the first XSP:
> 
> <?xml version="1.0"?>
> 
> <xsl:stylesheet version="1.0"
>    xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
>    xmlns:xsp="http://www.apache.org/1999/XSP/Core"
>    xmlns:esql="http://apache.org/cocoon/SQL/v2"
> >
> 
>   <xsl:template match="page">
> 
>     <xsl:processing-instruction
> name="cocoon-process">type="xsp"</xsl:processing-instruction>
>     <xsl:processing-instruction
> name="cocoon-process">type="xsp"</xsl:processing-instruction>
>     <xsl:processing-instruction
> name="xml-logicsheet">href="test-sql2.xsl"
> type="text/xsl"</xsl:processing-instruction>
> 
>     <xsp:page language="java"
> xmlns:xsp="http://www.apache.org/1999/XSP/Core"
>  
> xmlns:esql="http://apache.org/cocoon/SQL/v2">
> 
>       
>       <xsl:copy>
>         <xsl:apply-templates/>
>       </xsl:copy>
> 
>     </xsp:page>
>   </xsl:template>
> 
>  
>  
> 
> Can anyone tell me how to get Cocoon to reliably process the second
> XSP ( test-sql2.xsl )?  Does anyone have a better way to do this?
> I can provide more info on the DB Schema, or the other XSP/XML files,
> if needed.
> 
> tnx
> -m
> 
> 
> ======================================================================
> Matt Sabourin				Voice: 313.845.2529
> Systems Engineer			Fax:   313.317.6060
> Structural Dynamics Research Corp. 	Pager: 313.201.7741
> 1555 Fairlane Dr., Suite 300		Email: Matt.Sabourin@xxxxxxxx
> Allen Park, MI 48101			
> 
> AlphaPage: matt.sabourin@xxxxxxxxxxxxx
> AlphaPage: http://www.myairmail.com
> ======================================================================
> 
> 
>  XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
> 

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list