[xsl] SELECT DISTINCT QUERY

Subject: [xsl] SELECT DISTINCT QUERY
From: "Onur Esnaf" <oesnaf@xxxxxxxxxxxxxxx>
Date: Sat, 24 May 2003 09:44:19 +0300
I want to execute a SELECT DISTINCT querry in a node tree.

A have a node tree below

	<salesStaff>
		<person name="john" date="5/22/2003" time="10:00" duration="2" />
		<person name="john" date="5/22/2003" time="12:00" duration="1" />
		<person name="john" date="5/22/2003" time="13:00" duration="2" />
		<person name="marry" date="5/22/2003" time="12:00" duration="1" />
		<person name="bob" date="5/22/2003" time="9:00" duration="2" />
		<person name="bob" date="5/22/2003" time="11:00" duration="2" />
		<person name="john" date="5/22/2003" time="11:00" duration="2" />
		<person name="john" date="5/23/2003" time="10:00" duration="1" />
		<person name="jan" date="5/23/2003" time="10:00" duration="2" />
		<person name="sany" date="5/23/2003" time="19:00" duration="2" />
		<person name="marry" date="5/23/2003" time="15:00" duration="2" />
	</salesStaff>

	How can I have a query like "SELECT DISTINCT name FROM salesStaff WHERE date = $today"
	This will return the names of the salesmen who has an appointment today.
	But each name must be returned only once.

Thanks.
Onur



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


Current Thread