cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hubert NEOtyk Iwaniuk <hube...@office.ferienwelt.com.pl>
Subject [c2] q: howto use ESQL inside own logicsheets?
Date Mon, 03 Dec 2001 15:57:31 GMT
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message