Return-Path: 
 <cocoon-dev-return-18395-apmail-xml-cocoon-dev-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-dev-archive@xml.apache.org
Received: (qmail 1882 invoked by uid 500); 4 Nov 2001 22:20:08 -0000
Mailing-List: contact cocoon-dev-help@xml.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:cocoon-dev-help@xml.apache.org>
list-unsubscribe: <mailto:cocoon-dev-unsubscribe@xml.apache.org>
list-post: <mailto:cocoon-dev@xml.apache.org>
Reply-To: cocoon-dev@xml.apache.org
Delivered-To: mailing list cocoon-dev@xml.apache.org
Received: (qmail 1868 invoked from network); 4 Nov 2001 22:20:07 -0000
Date: Sun, 4 Nov 2001 17:20:12 -0500 (EST)
From: Tim Myers <phantom@stserv.hcf.jhu.edu>
To: <cocoon-dev@xml.apache.org>
Subject: esql grouping
In-Reply-To: <PLEFKGHLMIEKJKKFPNFIAEPPELAA.neeme.praks@one.ee>
Message-ID: <Pine.LNX.4.33.0111041703240.24686-200000@stserv.hcf.jhu.edu>
MIME-Version: 1.0
Content-Type: MULTIPART/MIXED; BOUNDARY="8323328-295347283-1004912412=:24686"
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

--8323328-295347283-1004912412=:24686
Content-Type: TEXT/PLAIN; charset=US-ASCII

I hope i'm sending this to the right list:

Attached is a diff to esql.xsl from the cocoon2rc1 release.

I have a change to the esql taglib which allows you to do something like
this:

<esql:execute-query>
  <esql:query>
    select committeeName, title, firstName, middleName, lastName, suffix,
status from committeeMember left join directoryInformation using(userid)
left join committee on committee.id=committeeMember.committeeid order by
committeeName asc
  </esql:query>
  <esql:results>
    <esql:row-results>
      <esql:group group-on="committeeName">
        <h2><esql:get-string column="committeeName"/></h2>
        <ul>
          <esql:member>
            <li>
              <esql:get-string column="title"/>
              <esql:get-string column="firstName"/>
              <esql:get-string column="middleName"/>
              <esql:get-string column="lastName"/>
              <esql:get-string column="suffix"/>
            </li>
          </esql:member>
        </ul>
      </esql:group>
    </esql:row-results>
  </esql:results>
</esql:execute-query>

That is, you can do table joins and then insert a header and footer
whenever a "watched" column value changes.  It follows the nesting
ideology of <xsp:logic>...<xsp:content></></>

You can nest <esql:group> and <esql:member> indefinately.  I didn't update
the schema, and it is probably undercommented... especially since i didn't
insert the xsp-doc stuff that would automatically stick documentation for
it on the esql website page.  I'll make any adjustments necesarry to it to
make it more worthy of inclusion in the released version.

Tim Myers
Student Technology Services
The Johns Hopkins University

--8323328-295347283-1004912412=:24686
Content-Type: TEXT/PLAIN; charset=US-ASCII; name="esqlgrouping.diff"
Content-Transfer-Encoding: BASE64
Content-ID: <Pine.LNX.4.33.0111041720120.24686@stserv.hcf.jhu.edu>
Content-Description: 
Content-Disposition: attachment; filename="esqlgrouping.diff"

SW5kZXg6IGVzcWwueHNsDQo9PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09DQpSQ1Mg
ZmlsZTogL3Zhci9jdnMvc3RzZXJ2L2VkdS9qaHUvaGNmL3N0c2Vydi9sb2dp
Y3NoZWV0cy9lc3FsLnhzbCx2DQpyZXRyaWV2aW5nIHJldmlzaW9uIDEuMQ0K
cmV0cmlldmluZyByZXZpc2lvbiAxLjINCmRpZmYgLXUgLWIgLXIxLjEgLXIx
LjINCi0tLSBlc3FsLnhzbAkyMDAxLzEwLzI1IDIwOjE3OjAwCTEuMQ0KKysr
IGVzcWwueHNsCTIwMDEvMTAvMjUgMjA6MTg6MzIJMS4yDQpAQCAtMSwxMiAr
MSwxMiBAQA0KIDw/eG1sIHZlcnNpb249IjEuMCI/Pg0KLTwhLS0gJElkOiBl
c3FsLnhzbCx2IDEuMSAyMDAxLzEwLzI1IDIwOjE3OjAwIHBoYW50b20gRXhw
ICQtLT4NCis8IS0tICRJZDogZXNxbC54c2wsdiAxLjIgMjAwMS8xMC8yNSAy
MDoxODozMiBwaGFudG9tIEV4cCAkLS0+DQogPCEtLQ0KIA0KICA9PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09DQogICAgICAgICAgICAgICAgICAg
IFRoZSBBcGFjaGUgU29mdHdhcmUgTGljZW5zZSwgVmVyc2lvbiAxLjINCiAg
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PQ0KIA0KLSBDb3B5cmln
aHQgKEMpIEB5ZWFyQCBUaGUgQXBhY2hlIFNvZnR3YXJlIEZvdW5kYXRpb24u
IEFsbCByaWdodHMgcmVzZXJ2ZWQuDQorIENvcHlyaWdodCAoQykgMTk5OS0y
MDAxIFRoZSBBcGFjaGUgU29mdHdhcmUgRm91bmRhdGlvbi4gQWxsIHJpZ2h0
cyByZXNlcnZlZC4NCiANCiAgUmVkaXN0cmlidXRpb24gYW5kIHVzZSBpbiBz
b3VyY2UgYW5kIGJpbmFyeSBmb3Jtcywgd2l0aCBvciB3aXRob3V0IG1vZGlm
aWNhLQ0KICB0aW9uLCBhcmUgcGVybWl0dGVkIHByb3ZpZGVkIHRoYXQgdGhl
IGZvbGxvd2luZyBjb25kaXRpb25zIGFyZSBtZXQ6DQpAQCAtNjc4LDIyICs2
NzgsOTEgQEANCiA8L3hzbDp0ZW1wbGF0ZT4NCiANCiA8eHNsOnRlbXBsYXRl
IG1hdGNoPSJlc3FsOnJlc3VsdHMvL2VzcWw6cm93LXJlc3VsdHMiPg0KKyAg
PHhzbDp2YXJpYWJsZSBuYW1lPSJncm91cCIgc2VsZWN0PSIuLy9lc3FsOmdy
b3VwIi8+DQogICA8eHNwOmxvZ2ljPg0KKyAgICBib29sZWFuIGtlZXBnb2lu
Zz1mYWxzZTsNCisNCisgICAgLy9jcmVhdGUgYm9vbGVhbnMgZm9yIGdyb3Vw
IGNoYW5nZSB3YXRjaGVzIGFuZCBzdHJpbmdzIGZvciBvbGQgdmFsdWVzLg0K
KyAgICA8eHNsOmFwcGx5LXRlbXBsYXRlcyBzZWxlY3Q9Ii4vL2VzcWw6Z3Jv
dXAiIG1vZGU9InZhcnMiLz4NCisNCiAgICAgZG8gew0KICAgICA8eHNwOmNv
bnRlbnQ+DQogICAgICAgPHhzbDphcHBseS10ZW1wbGF0ZXMvPg0KICAgICA8
L3hzcDpjb250ZW50Pg0KLSAgICAgIGlmIChfZXNxbF9jb25uZWN0aW9uLnVz
ZV9saW1pdF9jbGF1c2UgPT0gMCAmYW1wOyZhbXA7IF9lc3FsX3F1ZXJ5Lm1h
eF9yb3dzICE9IC0xICZhbXA7JmFtcDsgX2VzcWxfcXVlcnkucG9zaXRpb24g
LSBfZXNxbF9xdWVyeS5za2lwX3Jvd3MgPT0gX2VzcWxfcXVlcnkubWF4X3Jv
d3MtMSkgew0KLSAgICAgICAgX2VzcWxfcXVlcnkucG9zaXRpb24rKzsNCi0g
ICAgICAgIGJyZWFrOw0KLSAgICAgIH0NCi0gICAgICBfZXNxbF9xdWVyeS5w
b3NpdGlvbisrOw0KLSAgICB9IHdoaWxlIChfZXNxbF9xdWVyeS5yZXN1bHRz
ZXQubmV4dCgpKTsNCisgICAgICA8eHNsOmlmIHRlc3Q9ImNvdW50KCRncm91
cCkgJmx0OyAxIj4JDQorICAgICAgICA8eHNsOmNhbGwtdGVtcGxhdGUgbmFt
ZT0ibmV4dFJvdyIvPg0KKyAgICAgIDwveHNsOmlmPg0KKyAgICB9IHdoaWxl
IChrZWVwZ29pbmcpOw0KIA0KICAgICBpZiAoX2VzcWxfcXVlcnkucmVzdWx0
c2V0Lm5leHQoKSkgew0KICAgICAgIDx4c2w6YXBwbHktdGVtcGxhdGVzIHNl
bGVjdD0iZm9sbG93aW5nLXNpYmxpbmc6OmVzcWw6bW9yZS1yZXN1bHRzIiBt
b2RlPSJtb3JlIi8+DQogICAgICAgX2VzcWxfcXVlcnkucG9zaXRpb24rKzsN
CiAgICAgfQ0KKyAgPC94c3A6bG9naWM+DQorPC94c2w6dGVtcGxhdGU+DQor
DQorPHhzbDp0ZW1wbGF0ZSBuYW1lPSJuZXh0Um93Ij4NCisgIC8vY2hlY2tp
bmcgb3V0IGVhcmx5Pw0KKyAgaWYgKCBfZXNxbF9jb25uZWN0aW9uLnVzZV9s
aW1pdF9jbGF1c2UgPT0gMCAmYW1wOyZhbXA7IA0KKyAgICBfZXNxbF9xdWVy
eS5tYXhfcm93cyAhPSAtMSAmYW1wOyZhbXA7IA0KKyAgICBfZXNxbF9xdWVy
eS5wb3NpdGlvbiAtIF9lc3FsX3F1ZXJ5LnNraXBfcm93cyA9PSBfZXNxbF9x
dWVyeS5tYXhfcm93cy0xKSB7DQorICAgIF9lc3FsX3F1ZXJ5LnBvc2l0aW9u
Kys7DQorICAgIGtlZXBnb2luZyA9IGZhbHNlOw0KKyAgfSBlbHNlIHsJLy9p
ZiBub3QsIGFkdmFuY2Ugbm9ybWFsbHkNCisgICAga2VlcGdvaW5nID0gX2Vz
cWxfcXVlcnkucmVzdWx0c2V0Lm5leHQoKTsNCisgICAgX2VzcWxfcXVlcnku
cG9zaXRpb24rKzsNCisgIH0NCis8L3hzbDp0ZW1wbGF0ZT4NCisNCis8eHNs
OnRlbXBsYXRlIG1hdGNoPSJlc3FsOmdyb3VwIiBtb2RlPSJ2YXJzIj4NCisg
IGJvb2xlYW4gPHhzbDp2YWx1ZS1vZiBzZWxlY3Q9IkBncm91cC1vbiIvPkNo
YW5nZWQgPSB0cnVlOw0KKyAgU3RyaW5nIDx4c2w6dmFsdWUtb2Ygc2VsZWN0
PSJAZ3JvdXAtb24iLz5PbGQ7DQorPC94c2w6dGVtcGxhdGU+DQorDQorPHhz
bDp0ZW1wbGF0ZSBtYXRjaD0iZXNxbDpncm91cCI+DQorPHhzcDpsb2dpYz4N
CisgIGlmICg8eHNsOnZhbHVlLW9mIHNlbGVjdD0iQGdyb3VwLW9uIi8+Q2hh
bmdlZCl7CQ0KKyAgICAvL2hlYWRlciBjb250ZW50cw0KKyAgICA8eHNwOmNv
bnRlbnQ+DQorICAgICAgPHhzbDphcHBseS10ZW1wbGF0ZXM+DQorICAgICAg
ICA8eHNsOndpdGgtcGFyYW0gbmFtZT0iZ3JvdXAtb24iIHNlbGVjdD0iQGdy
b3VwLW9uIi8+DQorICAgICAgPC94c2w6YXBwbHktdGVtcGxhdGVzPg0KKyAg
ICA8L3hzcDpjb250ZW50Pg0KKyAgfQ0KKzwveHNwOmxvZ2ljPg0KKzwveHNs
OnRlbXBsYXRlPg0KKw0KKzx4c2w6dGVtcGxhdGUgbWF0Y2g9ImVzcWw6Z3Jv
dXAvL25vZGUoKVsuLy9lc3FsOm1lbWJlcl0iPg0KKyAgPHhzbDpwYXJhbSBu
YW1lPSJncm91cC1vbiIvPg0KKyAgPHhzbDpjb3B5Pg0KKyAgICA8eHNsOmFw
cGx5LXRlbXBsYXRlcyBzZWxlY3Q9IkAqfCp8dGV4dCgpIj4NCisgICAgICA8
eHNsOndpdGgtcGFyYW0gbmFtZT0iZ3JvdXAtb24iIHNlbGVjdD0iJGdyb3Vw
LW9uIi8+DQorICAgIDwveHNsOmFwcGx5LXRlbXBsYXRlcz4NCisgIDwveHNs
OmNvcHk+DQorPC94c2w6dGVtcGxhdGU+DQorDQorPHhzbDp0ZW1wbGF0ZSBt
YXRjaD0iZXNxbDptZW1iZXIiPg0KKyAgPHhzbDpwYXJhbSBuYW1lPSJncm91
cC1vbiIvPg0KKyAgPHhzbDp2YXJpYWJsZSBuYW1lPSJncm91cCIgc2VsZWN0
PSIuLy9lc3FsOmdyb3VwIi8+DQorICA8eHNwOmxvZ2ljPg0KKyAgfQ0KKyAg
ICA8eHNwOmNvbnRlbnQ+DQorICAgICAgPHhzbDphcHBseS10ZW1wbGF0ZXM+
DQorICAgICAgICA8eHNsOndpdGgtcGFyYW0gbmFtZT0iZ3JvdXAtb24iIHNl
bGVjdD0iJGdyb3VwLW9uIi8+DQorICAgICAgPC94c2w6YXBwbHktdGVtcGxh
dGVzPg0KKyAgICA8L3hzcDpjb250ZW50Pg0KKyAgICA8eHNsOnZhbHVlLW9m
IHNlbGVjdD0iJGdyb3VwLW9uIi8+T2xkID0gX2VzcWxfcXVlcnkucmVzdWx0
c2V0LmdldFN0cmluZygiPHhzbDp2YWx1ZS1vZiBzZWxlY3Q9IiRncm91cC1v
biIvPiIpOwkNCisNCisgICAgPHhzbDppZiB0ZXN0PSJjb3VudCgkZ3JvdXAp
ICZsdDsgMSI+CQ0KKyAgICAgIDx4c2w6Y2FsbC10ZW1wbGF0ZSBuYW1lPSJu
ZXh0Um93Ii8+DQorICAgIDwveHNsOmlmPg0KKyAgaWYgKGtlZXBnb2luZykg
ew0KKyAgICA8eHNsOnZhbHVlLW9mIHNlbGVjdD0iJGdyb3VwLW9uIi8+Q2hh
bmdlZCA9IDx4c2w6dmFsdWUtb2Ygc2VsZWN0PSIkZ3JvdXAtb24iLz5PbGQu
ZXF1YWxzKF9lc3FsX3F1ZXJ5LnJlc3VsdHNldC5nZXRTdHJpbmcoIjx4c2w6
dmFsdWUtb2Ygc2VsZWN0PSIkZ3JvdXAtb24iLz4iKSk7DQorICB9IGVsc2Ug
ew0KKyAgICA8eHNsOnZhbHVlLW9mIHNlbGVjdD0iJGdyb3VwLW9uIi8+Q2hh
bmdlZCA9IHRydWU7DQorICB9DQorICBpZiAoPHhzbDp2YWx1ZS1vZiBzZWxl
Y3Q9IiRncm91cC1vbiIvPkNoYW5nZWQpIHsJDQorICAgIC8vZm9vdGVyIGNv
bnRlbnRzDQogICA8L3hzcDpsb2dpYz4NCiA8L3hzbDp0ZW1wbGF0ZT4NCiAN
Cg==

--8323328-295347283-1004912412=:24686
Content-Type: text/plain; charset=us-ascii

---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org
--8323328-295347283-1004912412=:24686--