You are viewing a plain text version of this content. The canonical link for it is here.
Posted to cvs@cocoon.apache.org by ha...@apache.org on 2003/04/17 22:47:30 UTC
cvs commit: cocoon-2.1/src/blocks/databases/samples/xsp esql.xsp
haul 2003/04/17 13:47:30
Modified: src/blocks/databases/samples/xsp esql.xsp
Log:
add nested query
Revision Changes Path
1.3 +34 -1 cocoon-2.1/src/blocks/databases/samples/xsp/esql.xsp
Index: esql.xsp
===================================================================
RCS file: /home/cvs/cocoon-2.1/src/blocks/databases/samples/xsp/esql.xsp,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- esql.xsp 12 Mar 2003 11:08:59 -0000 1.2
+++ esql.xsp 17 Apr 2003 20:47:30 -0000 1.3
@@ -110,6 +110,39 @@
</esql:results>
</esql:execute-query>
+ <hr/>
+
+ <para>
+ This uses nested queries.
+ </para>
+
+ <esql:execute-query>
+ <esql:query>
+ SELECT name, id FROM department ORDER BY name
+ </esql:query>
+ <esql:results>
+ <esql:row-results>
+ <Department>
+ <xsp:attribute name='name'><esql:get-string column='name'/></xsp:attribute>
+ <h2><esql:get-string column='name'/></h2>
+
+ <esql:execute-query>
+ <esql:query>
+ select name from employee
+ where department_id = <esql:parameter type="int"><esql:get-int column="id" ancestor="1"/></esql:parameter>
+ </esql:query>
+ <esql:results>
+ <esql:row-results>
+ <para><employee><esql:get-string column='name'/></employee></para>
+ </esql:row-results>
+ </esql:results>
+ </esql:execute-query>
+
+ </Department>
+ </esql:row-results>
+ </esql:results>
+ </esql:execute-query>
+
</esql:connection>
</content>