Jessica,
ahem... I wrote: "could you please post the output of myfile.xml (in other words, the
input of myfile.xsl)", while you sent me the
"final" output (the one outputted by myfile.xsl).
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 11:29 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Output xsl --- next trap
>
>
> 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]>
>
---------------------------------------------------------------------
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]>
