Hi all,
i want my logicsheet to use ESQL, i try this:
<!-- my logicsheet -->
<xsl:stylesheet version="1.0"
xmlns:esql="http://apache.org/cocoon/SQL/v2";
xmlns:xsp="http://apache.org/xsp";
xmlns:my-logicsheet="http://my.org/my-logicsheet";
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
<xsl:template match="my-logicsheet:my-tag">
<esql:connection>
<esql:pool>my-pool</esql:pool>
<esql:execute-query>
<esql:query>SELECT * FROM my-table</esql:query>
<esql:results>
<esql:row-results>
<xsp:element name="my-element">
<xsp:attribute name="my-attr">
<esql:get-string
column="my-string-column"/>
</xsp:attribute>
</xsp:element>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
</xsl:template>
</xsl:stylesheet>
<!-- my server page -->
<xsp:page
xmlns:esql="http://apache.org/cocoon/SQL/v2";
xmlns:xsp="http://apache.org/xsp";
xmlns:my-logicsheet="http://my.org/my-logicsheet";>
<element-embding-my-tag>
<my-logisheet:my-tag>
</element-embding-my-tag>
</xsp:page>
<!-- output is -->
<element-embding-my-tag
<!-- namespace declarations -->
>
<esql:connection>
<esql:pool>fp</esql:pool>
<esql:execute-query>
<esql:query>SELECT * FROM my-table</esql:query>
<esql:results>
<esql:row-results>
<my-element my-attr=""/>
<!-- unprocessed esql tags -->
<!-- xsp has been processed -->
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
</element-embding-my-tag>
please tell me why i sthat so, and what i i need to understend to use this properly.
thanks in advance,
hubert.
---------------------------------------------------------------------
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]>
