Hi cocooners! I know that esql:get-row-count is unavailable yet. But I need to get this information from my DB. I try:
dbman.xsl <!-- - get employees count from database --> <xsl:template match="dbman:employees-count"> <count> <esql:connection> <esql:pool>mydb</esql:pool> <esql:execute-query> <esql:query> select count(*) CNT from EMP </esql:query> <esql:results> <esql:row-results><esql:get-string column="CNT"/></esql:row-results> </esql:results> <esql:no-results>0</esql:no-results> </esql:execute-query> </esql:connection> </count> </xsl:template> in my logicsheet. But I have trouble when I try to pass this value by using <dbman:employees-count/> as an attribute or xml entity to another logicsheet: any.xml <batch:navigator wrap="no"> <batch:action>employees</batch:action> <batch:batch><xsp-session:get-attribute name="employee-batch"/></batch:batch> <batch:batch-size><xsp-session:get-attribute name="employee-batch-size"/></batch:batch-size> <batch:element-count><dbman:employees-count/></batch:element-count> </batch:navigator> in my XML/XSP document. "batch" and "dbman" are my own logicsheets registered in cocoon.xconf - dbpool is registered too and dbdriver of course in web.xml. batch.xsl <xsl:template match="batch:navigator"> <xsl:param name="element-count" select="batch:element-count"/> <batch-navigator> <batch-count> <xsp:expr> (Long.parseLong(<xsl:value-of select="$element-count"/>) - 1) / Long.parseLong(<xsl:value-of select="$batch-size"/>.toString()) + 1 </xsp:expr> </batch-count> <element-count> <xsp:expr><xsl:value-of select="$element-count"/></xsp:expr> </element-count> </batch-navigator> </xsl:template> When I see into compiled java files I have NOTHING: this.contentHandler.startElement( "", "element-count", "element-count", xspAttr ); xspAttr.clear(); /* * AND? HERE SHOULD BE <xsl:value-of select="$element-count"/>!! * why it isn't??? */ this.contentHandler.endElement( "", "element-count", "element-count" ); What is the trouble with passing parameters between logicsheets? Please help. Jerzy Kut --------------------------------------------------------------------- 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]>