haul 02/04/09 05:37:10
Modified: src/webapp/docs/samples/xsp esql.xsp
Log:
patch 7184 by [EMAIL PROTECTED] (Tim Myers)
added esql:group to esql example.
(example extended - ch)
Revision Changes Path
1.5 +53 -3 xml-cocoon2/src/webapp/docs/samples/xsp/esql.xsp
Index: esql.xsp
===================================================================
RCS file: /home/cvs/xml-cocoon2/src/webapp/docs/samples/xsp/esql.xsp,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- esql.xsp 9 Feb 2002 06:21:57 -0000 1.4
+++ esql.xsp 9 Apr 2002 12:37:10 -0000 1.5
@@ -1,10 +1,10 @@
<?xml version="1.0" encoding="ISO-8859-1"?>
-<!-- CVS: $Id: esql.xsp,v 1.4 2002/02/09 06:21:57 vgritsenko Exp $ -->
+<!-- CVS: $Id: esql.xsp,v 1.5 2002/04/09 12:37:10 haul Exp $ -->
<xsp:page language="java"
xmlns:xsp="http://apache.org/xsp";
- xmlns:esql="http://apache.org/cocoon/SQL/v2";>
+ xmlns:esql="http://apache.org/cocoon/SQL/v2";>
<page>
<title>A Database Driven XSP Page</title>
@@ -22,8 +22,58 @@
</esql:row-results>
</esql:results>
</esql:execute-query>
- </esql:connection>
+ <hr/>
+
+ <para>
+ Below departments and employees are printed. This uses the grouping
+ feature in esql.
+ </para>
+
+ <esql:execute-query>
+ <esql:query>
+ SELECT department.name, employee.id, employee.name as empName FROM
department, employee
+ WHERE department.id = employee.department_id ORDER BY department.name
+ </esql:query>
+ <esql:results>
+ <esql:row-results>
+ <esql:group group-on='name'><!-- grouping -->
+ <Department>
+ <xsp:attribute name='name'><esql:get-string
column='name'/></xsp:attribute>
+ <h2><esql:get-string column='name'/></h2>
+ <esql:member><!-- grouping -->
+ <para><employee><esql:get-string
column='empName'/></employee></para>
+ </esql:member><!--grouping -->
+ </Department>
+ </esql:group><!-- grouping -->
+ </esql:row-results>
+ </esql:results>
+ </esql:execute-query>
+
+ <hr/>
+
+ <para>
+ Without the grouping feature, the result would look like this:
+ </para>
+
+ <esql:execute-query>
+ <esql:query>
+ SELECT department.name, employee.id, employee.name as empName FROM
department, employee
+ WHERE department.id = employee.department_id ORDER BY department.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>
+ <para><employee><esql:get-string
column='empName'/></employee></para>
+ </Department>
+ </esql:row-results>
+ </esql:results>
+ </esql:execute-query>
+
+ </esql:connection>
+
</content>
</page>
</xsp:page>
----------------------------------------------------------------------
In case of troubles, e-mail: [EMAIL PROTECTED]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
