cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andre Fiedler <andre.fied...@gmx.de>
Subject Re: SQLTransformer Help
Date Mon, 01 May 2006 12:02:14 GMT

thanks so far, but this did not solve the error. I also assume, the  
former version might have worked correctly, as the 'b's appear ..  
which could only happen, if the correct template was matched .. hm ..  
did the correction anyway, but no chages...
more or less my problem is in displaying the content of essen_titel,  
essen_beschreibung and essen_preis of the elements a layer deeper ..

>
> 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&uuml;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:rowset[@rowset='3']/sql:row would not work either, but  
> sql:rowset[@sql: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&uuml;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
> -------------------------------------------------------------
> a.schrijvers@hippo.nl / http://www.hippo.nl
> --------------------------------------------------------------
>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
>> For additional commands, e-mail: users-help@cocoon.apache.org
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message