Torsten Curdt wrote:
> Have a closer look - it is not a resultset. it's the
> result of the resultset.execute().
Oh yes, my miss.
> Could you grab the current version from CVS and send me your
> esql page and output. Up to know I cannot reproduce your problems...
Hi Torsten,
I got the snapshot from July 30th, 04:15 and run into the same problem.
One more problem is that if no rows are selected I even don't get the
header and footer in the output.
Here is my esql.xsp:
======================================================
<?xml version="1.0" encoding="UTF-8"?>
<xsp:page
xmlns:xsp="http://apache.org/xsp";
xmlns:esql="http://apache.org/cocoon/SQL/v2";
>
<page>
<esql:connection>
<esql:pool>my_pool</esql:pool>
<esql:execute-query>
<esql:query>select name, number
from employee
</esql:query>
<esql:results>
<header>
<name>EmpName</name>
<number>EmpNumber</number>
</header>
<esql:row-results>
<first-level>
<esql:get-columns/>
</first-level>
</esql:row-results>
<esql:no-results>
<user>no Values available</user>
</esql:no-results>
<footer>copyright</footer>
</esql:results>
</esql:execute-query>
</esql:connection>
</page>
</xsp:page>
======================================================
And here the xsl:
======================================================
<?xml version="1.0"?>
<xsl:stylesheet
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
version="1.0"
>
<xsl:template match="/page">
<html>
<body bgcolor="#FFFFFF">
<xsl:value-of select="header/name"/>
,
<xsl:value-of select="header/number"/>
<p/>
<xsl:for-each select="first-level">
<xsl:value-of select="name"/>
,
<xsl:value-of select="number"/>
<br/>
</xsl:for-each>
<p><xsl:value-of select="user"/></p>
<p><xsl:value-of select="footer"/></p>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
======================================================
The output from Cocoon-2.0b1 was this if rows are selected:
======================================================
<html>
<body bgcolor="#FFFFFF">EmpName
,
EmpNumber<p></p>King
,
1<br>Scott
,
2<br>Smith
,
3<br>Tiger
,
4<br>
<p></p>
<p>copyright</p>
</body>
</html>
======================================================
and if NO rows are selected:
======================================================
<html>
<body bgcolor="#FFFFFF">EmpName
,
EmpNumber<p></p>
<p>no Values available</p>
<p>copyright</p>
</body>
</html>
======================================================
The output from Cocoon-2.0b2 and also for the actual snapshot
is this, if rows are selected:
======================================================
<html>
<body bgcolor="#FFFFFF">EmpName
,
EmpNumber<p></p>King
,
1<br>Scott
,
2<br>Smith
,
3<br>Tiger
,
4<br>
<p>no Values available</p>
<p>copyright</p>
</body>
</html>
======================================================
and if NO rows are selected - header, noValues and footer is missing
======================================================
<html>
<body bgcolor="#FFFFFF">
,
<p></p>
<p></p>
<p></p>
</body>
</html>
======================================================
I hope that you have any idea why this happens only to me.
I use tomcat 3.2.3 with lib/parser.jar copied from
xml-cocoon/lib/xerces_1_4_1.jar, Linux (SuSE 7.1) with
SDK2 version 1.3 and I removed regularly the work-directory
With best regards,
Michael
---------------------------------------------------------------------
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
