Subject: grouping question
From: Patrick Moore <patrickm@xxxxxxxxxxx>
Date: Thu, 12 Apr 2001 17:44:59 -0700
|
Hi there --
I have looked through the email about grouping withput finding this question
being answered.
I am using Xalan sql extension to generate the data that will be processed
by the xsl stylesheet. Because it is a database query I have constructed the
query so the results are sorted based on the element that I wish to group
by. Because this extension lets me look at only one row at a time, and I
cannot go back, the Mueschean method is not possible. (Or at least not
prefered).
I was wondering if anyone had some thoughts on a way I can take advantage of
the ordering that SQL can do to come up with a simpler method. Some sample
data:
<rowset>
<row><album>1</album><track_id>1</track_id><artist>Rush</artist></row>
<row><album>1</album><track_id>2</track_id><artist>Rush</artist></row>
<row><album>2</album><track_id>1</track_id><artist>Rush</artist></row>
<row><album>2</album><track_id>2</track_id><artist>Rush</artist></row>
</rowset>
As soon as I see the "Album 2" I know that there are no more
<album>1</album>'s Can I take advantage of this in any manner?
My preliminary conclusion is no... but I am new enough to xsl to wonder if
this is indeed the case.
-Patrick Moore
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
| Current Thread |
- grouping question
- Patrick Moore - Thu, 12 Apr 2001 20:45:32 -0400 (EDT) <=
- <Possible follow-ups>
- Patrick Moore - Thu, 12 Apr 2001 21:34:13 -0400 (EDT)
|
|