Hallo everybody,

I have the following problem. I transform an sql statement by a xsl stylsheet:
which looks like the following:

<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
               xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
               xmlns:sql="http://apache.org/cocoon/SQL/2.0";
               xmlns:ft="http://apache.org/cocoon/forms/1.0#template";>
<xsl:template match="/page">
<html>
 <body>
     <table border = "1">
           <xsl:copy-of select="sql:email"/>
     <xsl:apply-templates/>
   </table>
 </body>
</html>
</xsl:template>
.................................

Everything works fine except the copy-of select statement. I want to acces a single field from the sql statement. When I type <xsl:copy-of select="."/> cocoon prints the whole resultset to the screen. I already tried ${sql:email}, or thing like name()="sql:email", but nothing works for me. Thanks for any advice.

The sitemap statement looks like this:

<map:match pattern = "runsql">
        <map:generate src="resource/internal/sql/sql.xml"/>
        <map:transform type="sql">
                   <map:parameter name="use-connection" value="personnel"/>
                   <map:parameter name="show-nr-of-rows" value="true"/>
                   <map:parameter name="clob-encoding" value="UTF-8"/>
        </map:transform>
        <map:transform src="resource/internal/transform2Table.xsl"/>
       <map:serialize type="html"/>
</map:match>

cheers

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to