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]>