See in code: > > > Hi everybody, > > I am creating a cocoon application talking to a database, extracting > the basic information via SQLTransformer and let it be displayed. So > far so good .. almost everything is fine, instead of one > thing. After > database communication creates the XML-file in (A) my XSLT > (B) should > transform it and give the output in a table .. But even after > successfully calling the correct template and print some nonsens for > debugging purposes I am still not able to address the sql createt > elements in the XML-file one level deeper ... :-/ u know what I > meen ? let me show you: > > (A) generated XML File > -------------------------------- > > <speiseplan xmlns:xi="http://www.w3.org/2001/XInclude";> > <tage nrofrows="5" name="tage" > xmlns:sql="http://apache.org/cocoon/ > SQL/2.0" xmlns="http://apache.org/cocoon/SQL/2.0";> > <tag> > <tag_id>1</tag_id> > <tag_name>Montag</tag_name> > </tag> > <tag> > <tag_id>2</tag_id> > <tag_name>Dienstag</tag_name> > </tag> > <tag> > <tag_id>3</tag_id> > <tag_name>Mittwoch</tag_name> > </tag> > <tag> > <tag_id>4</tag_id> > <tag_name>Donnerstag</tag_name> > </tag> > <tag> > <tag_id>5</tag_id> > <tag_name>Freitag</tag_name> > </tag> > </tage> > <content> > <rowset nrofrows="3" > xmlns:sql="http://apache.org/cocoon/SQL/2.0"; > xmlns="http://apache.org/cocoon/SQL/2.0";> > <row> > <essen_titel>Essen 1</essen_titel> > <essen_beschreibung>Senfeier > mit Backkartoffeln und > Schwarzwurzeln</essen_beschreibung> > <essen_preis>2.5</essen_preis> > </row> > <row> > <essen_titel>Essen 2</essen_titel> > > <essen_beschreibung>Tomatensuppe, dazu Basilikum. Croutons und > Gewürze der Provence</essen_beschreibung> > <essen_preis>2.99</essen_preis> > </row> > <row> > <essen_titel>Bio-Essen</essen_titel> > <essen_beschreibung>Spaghetti > Bolognese mit frischem Parmesan</ > essen_beschreibung> > <essen_preis>3.8</essen_preis> > </row> > </rowset> > </content> > </speiseplan> > > > (B) XSLT extract > ---------------------- > ... > <xsl:template name="tag" match="sql:rowset"> > <br/> <br/> > <p class="p"> > <xsl:value-of select="$var"/> > </p> > <br/> <br/> > <table width="600" class="content_table" cellpadding="5" > cellspacing="0"> > <tr> > <td class="content_table_top" width="20%">Titel</td> > <td class="content_table_top" > width="60%">Beschreibung</td> > <td class="content_table_top" width="20%">Preis in > EURO</td> > </tr> > <xsl:call-template name="essen"/> > </table> > </xsl:template> > > > <xsl:template name="essen" match="rowset/sql:row">
Here you have a mistake: rowset belongs to the sql namespace, so use sql:rowset/sql:row. Always watch out for namespaces, they are tricky. Once you are familiaar with it, you know where to look (for example, sql:[EMAIL PROTECTED]'3']/sql:row would not work either, but sql:[EMAIL PROTECTED]:rowset='3']/sql:row would) > <tr> > <td class="content_table_td" width="20%">b<xsl:value-of > select="sql:essen_titel"/></td> > <td class="content_table_td" width="60%">b<xsl:value-of > select="sql:essen_beschreibung"/></td> > <td class="content_table_td" width="20%">b<xsl:value-of > select="sql:essen_preis"/></td> > </tr> > </xsl:template> > ... > > > (C) generated HTML extract > -------------------------------------- > ... > <table cellspacing="0" cellpadding="5" class="content_table" > width="600"> > <tr> > <td width="20%" class="content_table_top">Titel</td><td width="60%" > class="content_table_top">Beschreibung</td><td width="20%" > class="content_table_top">Preis in EURO</td> > </tr> > <tr> > <td width="20%" class="content_table_td">b</td><td width="60%" > class="content_table_td">b</td><td width="20%" > class="content_table_td">b</td> > </tr> > </table> > > Essen 1Senfeier mit Backkartoffeln und Schwarzwurzeln2.5Essen > 2Tomatensuppe, dazu Basilikum. Croutons und Gewürze der > Provence2.99Bio-EssenSpaghetti Bolognese mit frischem Parmesan3.8 > > > (D) > ----- > Obvisously I want the Entries "Essen 1..." appear in the table and > not afterwards .. :-( and do undergo that mechanism as much as row- > elements appear, not only once as it is now .. (rember the rows of > "b" in (A)) > > Do you know an answer to that? currently it has driving me crazy for > 5 hours .. > > thanks and greetings > > Andre > Regards Ard -- Hippo Oosteinde 11 1017WT Amsterdam The Netherlands Tel +31 (0)20 5224466 ------------------------------------------------------------- [EMAIL PROTECTED] / http://www.hippo.nl -------------------------------------------------------------- > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
