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 |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] looping through result tr, Wendell Piez | Thread | RE: [xsl] SELECT DISTINCT QUERY, Martin Rowlinson \(M |
Re: [xsl] looping through result tr, S Woodside | Date | RE: [xsl] SELECT DISTINCT QUERY, Martin Rowlinson \(M |
Month |