grouping question

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