cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Askild Aaberg Olsen <>
Subject Re: Named queries in SQLTransformer
Date Thu, 10 Nov 2005 15:43:10 GMT
Oleg Konovalov wrote:

>I've read a lot of Cocoon documentation on the net and books, 
>especially regarding SQL Transformer. 
>It does mention that queries might be named.
>So if I have several SQL queries in SQLTransformer (e.g. query1,
>query2), what is a convention for the output ?
><page xmlns:sql="">  
>  <sql:execute-query>
>    <sql:query name="query1">  
>	FROM custtable 
>	WHERE cust_id=<sql:substitute-value sql:name="cust_id"/>
>I need to pickup this SQLTransformer output (few rowsets) as an
>input into XSLT->HTML transformer/serializer,
>something like:
><xsl:variable name='rowset1'
>select='/page/content/paging/data/query1'/> ?
It adds an attribute named "name" to the rowset, like:

<xsl:value-of select="/sqlpart/sql:rowset[@name='query1']/sql:row/sql:thisfield"/>

I'm not 100% sure this is the right output (just looked in , but why don't you just look at the pipeline output?


To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message