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">
<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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
