cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From S├ębastien Lefebvre <slefeb...@i2m.fr>
Subject Problem getting xml from DB
Date Wed, 22 Aug 2001 08:03:03 GMT
Hi,


I try to get xml from my DB (MySQL), here is my piece of code :
<esql:execute-query>
<esql:query>SELECT piano from TFiche where 
IdFiche=<esql:parameter><request:get-parameter 
name="idfiche"/></esql:parameter></esql:query>
<esql:results>
<esql:row-results>
<sebas>
<esql:get-xml column="piano"/>
</sebas>
</esql:row-results>
</esql:results>
</esql:execute-query>

node <sebas> is a child of <page>  so I have /page/sebas

here is the piece of xml in my DB :

<piano><couleurclaire>#B1DFB0</couleurclaire><couleurfoncee>#A4D1FF</couleurfoncee></piano>


When I try to apply a template in my XSL stylesheet, it does not apply 
the template but, instead, write the values of <couleurclaire> and 
<couleurfoncee>


....
<xsl:apply-templates select="/page/sebas"/
</body>
</html>
</xsl:template>


<xsl:template name="/page/sebas"/>
<h1>Hello</h1> <!--DOES NOT DISPLAY "HELLO" -->
</xsl:template>

Does you have any idea (I'm sure you have ;-) ) ?
What does the "root" argument of esql:get-xml mean ?

Thanks a lot

S├ębastien



---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

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


Mime
View raw message