Selecting unique elements

[Adam Van Den Hoven <Adam.Hoven@xxxxxxxxxxxx>]

Hi, 

I'm building a transform for a saved ADO recordset and I need to select
unique values. I thought that I could use 

//row[preceding-sibling::row/attribute::UserName !=
attribute::UserName]/attribute::UserName

It didn't work (well, it didn't return an error, it just didn't result in
anything useful so either the current version of MSMXL doesn't have these
features or I'm missed some important point.

any suggestions?

(my data)
<rs:data>
	<z:row UserName='bar' ResourceTypeCode='2' ResourceID='69'
Description='v' ListField='video clip' />
	<z:row UserName='bar' ResourceTypeCode='4' ResourceID='9'
Description='p' ListField='Pilar&#x27;s Poll 1' />
	<z:row UserName='bar' ResourceTypeCode='4' ResourceID='42'
Description='p' ListField='new' />
	<z:row UserName='bar' ResourceTypeCode='4' ResourceID='43'
Description='p' ListField='y' />
	<z:row UserName='bar' ResourceTypeCode='4' ResourceID='44'
Description='p' ListField='t' />
	<z:row UserName='bar' ResourceTypeCode='6' ResourceID='1'
Description='i' ListField='blank' />
	<z:row UserName='bar' ResourceTypeCode='6' ResourceID='48'
Description='i' ListField='toni14' />
	<z:row UserName='bar' ResourceTypeCode='7' ResourceID='6'
Description='s' ListField='newsbz' />
	<z:row UserName='bar' ResourceTypeCode='7' ResourceID='10'
Description='s' ListField='I smell old people' />
	<z:row UserName='bar' ResourceTypeCode='7' ResourceID='16'
Description='s' ListField='Captain Poopie lays down the LAW!' />
	<z:row UserName='bar' ResourceTypeCode='7' ResourceID='35'
Description='s' ListField='PUBLISHTEST1' />
	<z:row UserName='foo' ResourceTypeCode='2' ResourceID='20'
Description='v' ListField='Test Clip 1111' />
	<z:row UserName='foo' ResourceTypeCode='2' ResourceID='68'
Description='v' ListField='clip ok' />
	<z:row UserName='foo' ResourceTypeCode='4' ResourceID='7'
Description='p' ListField='3' />
	<z:row UserName='foo' ResourceTypeCode='4' ResourceID='9'
Description='p' ListField='Pilar&#x27;s Poll 1' />
	<z:row UserName='foo' ResourceTypeCode='4' ResourceID='47'
Description='p' ListField='asdf' />
	<z:row UserName='foo' ResourceTypeCode='5' ResourceID='15'
Description='t' ListField='t' />
	<z:row UserName='foo' ResourceTypeCode='5' ResourceID='18'
Description='t' ListField='t' />
	<z:row UserName='foo' ResourceTypeCode='5' ResourceID='7085'
Description='t' ListField='TextHeadline2' />
	<z:row UserName='foo' ResourceTypeCode='7' ResourceID='4'
Description='s' ListField='old people forum' />
	<z:row UserName='foo' ResourceTypeCode='7' ResourceID='6'
Description='s' ListField='newsbz' />
	<z:row UserName='foo' ResourceTypeCode='7' ResourceID='9'
Description='s' ListField='DONTDELETE' />
	<z:row UserName='foo' ResourceTypeCode='7' ResourceID='12'
Description='s' ListField='Senior Citizen discount increase' />
	<z:row UserName='foo' ResourceTypeCode='7' ResourceID='16'
Description='s' ListField='Captain Poopie lays down the LAW!' />
	<z:row UserName='system' ResourceTypeCode='4' ResourceID='9'
Description='p' ListField='Pilar&#x27;s Poll 1' />
	<z:row UserName='system' ResourceTypeCode='7' ResourceID='12'
Description='s' ListField='Senior Citizen discount increase' />
</rs:data>

> 		Adam van den Hoven
> 		Internet Application Developer
> 		Blue Zone
> 		tel. 604.685.4310
> 		fax. 604.685.4391
> 
> Blue Zone makes news interactive. http://www.bluezone.net/
> 
> 
> 
> 


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list