[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Complex Sorting Help
In the following example, I am trying to return the Property with the cheapest TOTAL rate first. What I WANT to do is something like, this, but of course it doesn't work... Any ideas how to get the desired results? XML: <Properties> <Property Name="My Hotel"> <Room Name="King Room"> <Day Date="04/15/2006" Quantity="2" Price="180.00"/> <Day Date="04/15/2006" Quantity="2" Price="180.00"/> <Day Date="04/15/2006" Quantity="2" Price="100.00"/> </Room> <Room Name="Suite"> <Day Date="04/15/2006" Quantity="2" Price="280.00"/> <Day Date="04/15/2006" Quantity="2" Price="280.00"/> <Day Date="04/15/2006" Quantity="2" Price="240.00"/> </Room> </Property> <Property Name="Other Hotel"> <Room Name="Queen Room"> <Day Date="04/15/2006" Quantity="2" Price="150.00"/> <Day Date="04/15/2006" Quantity="2" Price="165.00"/> <Day Date="04/15/2006" Quantity="2" Price="165.00"/> </Room> </Property> </Properties> XSL: <xsl:for-each select="Property"> <xsl:sort order="ascending" data-type="number" select="Room/sum(Day/@Price)"/> <br/><br/> <xsl:value-of select="@Name"/> <br/> <xsl:for-each select="Room">   <xsl:value-of select="@Name"/> : <xsl:value-of select="sum(Day/@Price)"/> </xsl:for-each> </xsl:for-each> DESIRED RESULTS: My Hotel King Room: 460.00 Suite: 800.00 Your Hotel Queen Room: 480.00
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|