cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Enke Michael <Michael.E...@wincor-nixdorf.com>
Subject Re: [c2][patch] RE: ESQL : No, my problem isn't with mutual exclusivity
Date Mon, 30 Jul 2001 09:36:45 GMT
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message