[XSL-LIST Mailing List Archive Home] [By Thread] [By Date]

[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