At 11.00 30/09/2002 +0200, you wrote:

Thank you a lot for your answer :

> > I hope you wanted the output of the xml file in the browser ....
> >
>
>Well, I'd like the "tagged" version of it ("View / Page source" would do)

My "tagged" version:


html xmlns:xs="http://www.w3.org/2001/XMLSchema";>
<head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<br>title document 1<br>
<br>dummy content doc 1<br>
10
<br>Author1<br>
<br>
<br>Section A Section B
<br>Content of section A Content of section B<br>
<br>
<br>chapter 3 chapter 2 chapter 1
<br>content chapter 3 content chapter 2 content chapter 1
<br>
<br>
<br>Paragraph 5 Paragraph 4
<br> Content of Paragraph 5 Content of Paragraph 4
<br>
<br>
<br>Paragraph 2
<br>Content of Paragraph 2
<br>
<br>
<br>Paragraph 1 Paragraph 3
<br>Content of Paragraph 1 Content of Paragraph 3
<br>
<br>
<br>
<br>chapter 4 chapter 5
<br>content chapter 4 content chapter 5
<br>
<br>
<br>Paragraph 6
<br>Content of Paragraph 6
<br>
<br>
<br>Paragraph 7
<br>Content of Paragraph 7
<br>
<br>
<br>
<br>
<br>
<br>
</body>
</html>






> > Because I work in Italy ?!
>
>Makes sense.

Hope so !




>Best regards,
>
>---------------------------------------------
>                Luca Morandini
>                GIS Consultant
>               [EMAIL PROTECTED]
>http://utenti.tripod.it/lmorandini/index.html
>---------------------------------------------
>
>
> > -----Original Message-----
> > From: Jessica Niewint [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, September 30, 2002 10:47 AM
> > To: [EMAIL PROTECTED]
> > Subject: RE: Output xsl --- next trap
> >
> >
> > At 20.40 27/09/2002 +0200, you wrote:
> > >Jessica,
> > >
> > >three things:
> > >
> > >1) could you please post the output of myfile.xml (in other words, the
> > >input of myfile.xsl) ?
> >
> > I hope you wanted the output of the xml file in the browser ....
> >
> >
> > output:
> >
> > title document 1
> >
> > dummy content doc 1
> > 10
> > Author1
> >
> >
> > Section A Section B
> > Content of section A Content of section B
> >
> >
> > chapter 3 chapter 2 chapter 1
> > content chapter 3 content chapter 2 content chapter 1
> >
> >
> > Paragraph 5 Paragraph 4
> > Content of Paragraph 5 Content of Paragraph 4
> >
> >
> > Paragraph 2
> > Content of Paragraph 2
> >
> >
> > Paragraph 1 Paragraph 3
> > Content of Paragraph 1 Content of Paragraph 3
> >
> >
> >
> > chapter 4 chapter 5
> > content chapter 4 content chapter 5
> >
> >
> > Paragraph 6
> > Content of Paragraph 6
> >
> >
> > Paragraph 7
> > Content of Paragraph 7
> >
> >
> >
> >
> > >2) could you tell me why the output is in Italian ?
> >
> >
> > Because I work in Italy ?!
> >
> >
> > >3) could you use plain text for messages ?
> >
> > Yes, it was a mistake (I was too quick with my mouse click ;-)).
> > Sorry again
> >
> >
> > >Best regards,
> > >
> > >---------------------------------------------
> > >                Luca Morandini
> > >                GIS Consultant
> > >               [EMAIL PROTECTED]
> > >http://utenti.tripod.it/lmorandini/index.html
> >
> >
> >
> >
> > >HI it's me again.
> > >
> > >With this xml file I get the right chapters for the right sections and the
> > >right sections for the right document.
> > >Only that my output is something like this
> > >document
> > >section A section B
> > >chapter 1 chapter 2
> > >chapter 3
> > >
> > >
> > >I wanted to generate a document structure like this:
> > >document
> > >section A
> > >chapter 1
> > >chapter 2
> > >section B
> > >chapter 3
> > >
> > >
> > >
> > >I have no idea if my way how to use  the esql -query is wrong or if I have
> > >change the xsl file.
> > >
> > >But may some one just give me a hint ...
> > >
> > >Thank you in advance ...
> > >J.
> > >
> > >I will post again my xml and my xsl file. Sorry for this long posting.
> > <?xml version="1.0" encoding="UTF-8"?>
> > <xsp:page laguage="java" xmlns:xsp="http://apache.org/xsp";
> > xmlns:esql="http://apache.org/cocoon/SQL/v2";>
> >          <!-- Get Document -->
> >          <Document xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
> > xsi:noNamespaceSchemaLocation="schema.xsd"
> > xmlns:esql="http://apache.org/cocoon/SQL/v2"; 
> xmlns:xsp="http://apache.org/xsp";>
> >                  <esql:connection>
> >                          <esql:pool>xmldb</esql:pool>
> >                          <xsp:logic> String document= "1";</xsp:logic>
> >                          <esql:execute-query>
> >                                  <esql:query>select * from document where
> > DocID=<xsp:expr>document</xsp:expr>
> >                                  </esql:query>
> >                                  <esql:results>
> >                                          <esql:row-results>
> >                                                  <DocObj>
> >                                                          <esql:get-string
> > column="DocObject"/>
> >                                                  </DocObj>
> >                                                  <DocTitle>
> >                                                          <esql:get-string
> > column="DocTitle"/>
> >                                                  </DocTitle>
> >                                                  <DocVer>
> >                                                          <esql:get-string
> > column="DocVersion"/>
> >                                                  </DocVer>
> >                                                  <DocAuth>
> >                                                          <esql:get-string
> > column="DocAuthor"/>
> >                                                  </DocAuth>
> >                                                  <DocDate>
> >                                                          <esql:get-date
> > column="DocData"/>
> >                                                  </DocDate>
> >                                                  <!-- Get Sections-->
> >                                                  <Section>
> > 
> <esql:execute-query>
> > 
> <esql:query>select
> > BuildSecID, SecID from secbuild where DocID=<xsp:expr>document</xsp:expr>
> > order by SecOrdine</esql:query>
> > 
> <esql:results>
> > 
>   <esql:row-results>
> > 
>           <xsp:logic>
> > 
>             String
> > buildSecID = <esql:get-string column="BuildSecID"/>;
> > 
>             String
> > section = <esql:get-string column="SecID"/>;
> > 
>      </xsp:logic>
> > 
>           <esql:execute-query>
> > 
>                   <esql:query>select
> > * from section where SecID=<xsp:expr>section</xsp:expr>
> > 
>                   </esql:query>
> > 
>                   <esql:results>
> > 
>                           <esql:row-results>
> > 
>                                   <SecTitle>
> > 
>                                           <esql:get-string
> > column="SecTitle"/>
> > 
>                                   </SecTitle>
> > 
>                                   <SecContent>
> > 
>                                           <esql:get-string
> > column="SecContent"/>
> > 
>                                   </SecContent>
> > 
>                                   <!--
> > Get Chapter -->
> > 
>                                   <Chapter>
> >
> > <esql:execute-query>
> >
> > <esql:query>select
> > BuildChapID, ChapID from chapbuild where
> > BuildSecID=<xsp:expr>buildSecID</xsp:expr> order by ChapOrdine</esql:query>
> >
> > <esql:results>
> >
> >        <esql:row-results>
> >
> >                <xsp:logic>
> > 
>                                                    String
> > buildchapID = <esql:get-string column="BuildChapID"/>;
> > 
>                                                 String
> > chapter = <esql:get-string column="ChapID"/>;
> > 
>                                             </xsp:logic>
> >
> >                <esql:execute-query>
> >
> >                        <esql:query>select
> > * from chapter where ChapID=<xsp:expr>chapter</xsp:expr>
> >
> >                        </esql:query>
> >
> >                        <esql:results>
> >
> >                                <esql:row-results>
> >
> >                                        <ChapTitle>
> >
> >                                                <esql:get-string
> > column="ChapTitle"/>
> >
> >                                        </ChapTitle>
> >
> >                                        <ChapContent>
> >
> >                                                <esql:get-string
> > column="ChapContent"/>
> >
> >                                        </ChapContent>
> >
> >                                        <Paragraph>
> >
> >                                                <esql:execute-query>
> >
> >                                                        <esql:query>select
> > ParaID from parabuild where BuildChapID=<xsp:expr>chapter</xsp:expr> order
> > by ParaOrdine</esql:query>
> >
> >                                                        <esql:results>
> >
> > 
> <esql:row-results>
> >
> > 
> <xsp:logic>
> >
> >                                                           String
> > paragraph = <esql:get-string column="ParaID"/>;
> >
> >                                                </xsp:logic>
> >
> > 
> <esql:execute-query>
> >
> > 
>         <esql:query>select
> > * from paragraph where ParaID=<xsp:expr>paragraph</xsp:expr>
> >
> > 
>         </esql:query>
> >
> > 
>         <esql:results>
> >
> > 
>                 <esql:row-results>
> >
> > 
>                         <ParaTitle>
> >
> > 
>                                 <esql:get-string
> > column="ParaTitle"/>
> >
> > 
>                         </ParaTitle>
> >
> > 
>                         <ParaContent>
> >
> > 
>                                 <esql:get-string
> > column="ParaContent"/>
> >
> > 
>                         </ParaContent>
> >
> > 
>                 </esql:row-results>
> >
> > 
>         </esql:results>
> >
> > 
> </esql:execute-query>
> >
> > 
> </esql:row-results>
> >
> >                                                        </esql:results>
> >
> >                                                </esql:execute-query>
> >
> >                                        </Paragraph>
> >
> >                                </esql:row-results>
> >
> >                        </esql:results>
> >
> >                </esql:execute-query>
> >
> >        </esql:row-results>
> >
> > </esql:results>
> >
> > </esql:execute-query>
> > 
>                                   </Chapter>
> > 
>                           </esql:row-results>
> > 
>                   </esql:results>
> > 
>           </esql:execute-query>
> > 
>   </esql:row-results>
> > 
> </esql:results>
> > 
> </esql:execute-query>
> >                                                  </Section>
> >                                          </esql:row-results>
> >                                  </esql:results>
> >                          </esql:execute-query>
> >                  </esql:connection>
> >          </Document>
> > </xsp:page>
> >
> >
> > >myfile.xsl:
> > <?xml version="1.0" encoding="UTF-8"?>
> > <xsl:stylesheet version="1.0"
> > xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
> > xmlns:xs="http://www.w3.org/2001/XMLSchema";>
> >          <xsl:template match="/">
> >                  <html>
> >                          <head/>
> >                          <body>
> >                                  <xsl:for-each select="Document">
> >                                          <br/>
> >                                          <xsl:for-each select="DocTitle">
> >                                                  <xsl:apply-templates/>
> >                                          </xsl:for-each>
> >                                          <br/>
> >                                          <br/>
> >                                          <xsl:for-each select="DocObj">
> >                                                  <xsl:apply-templates/>
> >                                          </xsl:for-each>
> >                                          <br/>
> >                                          <xsl:for-each select="DocVer">
> >                                                  <xsl:apply-templates/>
> >                                          </xsl:for-each>
> >                                          <br/>
> >                                          <xsl:for-each select="DocAuth">
> >                                                  <xsl:apply-templates/>
> >                                          </xsl:for-each>
> >                                          <br/>
> >                                          <br/>
> >                                          <xsl:for-each select="Section">
> >                                                  <br/>
> >                                                  <xsl:for-each
> > select="SecTitle">
> > 
> <xsl:apply-templates/>
> >                                                  </xsl:for-each>
> >                                                  <br/>
> >                                                  <xsl:for-each
> > select="SecContent">
> > 
> <xsl:apply-templates/>
> >                                                  </xsl:for-each>
> >                                                  <br/>
> >                                                  <br/>
> >                                                  <xsl:for-each
> > select="Chapter">
> >                                                          <br/>
> >                                                          <xsl:for-each
> > select="ChapTitle">
> > 
> <xsl:apply-templates/>
> >                                                          </xsl:for-each>
> >                                                          <br/>
> >                                                          <xsl:for-each
> > select="ChapContent">
> > 
> <xsl:apply-templates/>
> >                                                          </xsl:for-each>
> >                                                          <br/>
> >                                                          <br/>
> >                                                          <xsl:for-each
> > select="Paragraph">
> >                                                                  <br/>
> > 
> <xsl:for-each
> > select="ParaTitle">
> > 
>   <xsl:apply-templates/>
> > 
> </xsl:for-each>
> >                                                                  <br/>
> > 
> <xsl:for-each
> > select="ParaContent">
> > 
>   <xsl:apply-templates/>
> > 
> </xsl:for-each>
> >                                                                  <br/>
> >                                                                  <br/>
> >                                                          </xsl:for-each>
> >                                                          <br/>
> >                                                  </xsl:for-each>
> >                                                  <br/>
> >                                          </xsl:for-each>
> >                                          <br/>
> >                                          <br/>
> >                                  </xsl:for-each>
> >                          </body>
> >                  </html>
> >          </xsl:template>
> > </xsl:stylesheet>
> >
> >
> > ---------------------------------------------------------------------
> > Please check that your question  has not already been answered in the
> > FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>
> >
> > To unsubscribe, e-mail:     <[EMAIL PROTECTED]>
> > For additional commands, e-mail:   <[EMAIL PROTECTED]>
> >
>
>
>---------------------------------------------------------------------
>Please check that your question  has not already been answered in the
>FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>
>
>To unsubscribe, e-mail:     <[EMAIL PROTECTED]>
>For additional commands, e-mail:   <[EMAIL PROTECTED]>


---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Reply via email to