XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XQuery Help and Discussion » XSLT sorting parent nodes by multiple child nodes
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
- XQuery Help and Discussion (2017)
-> + Issue with Processing Instruct... (2)
-> + problem converting json to XML... (2)
-> + Problem base64 decoding string... (3)
-> + Problems posting multipart for... (5)
-> + trouble with download of price... (2)
-> + Problem with http-post not bei... (3)
-> + path problem, xps_file:writeAl... (9)
-> + Xquery update support? (2)
-> + problem with Stylus studio try... (5)
-> + adding dtd reference to xml ou... (4)
-> + xquery escaping ambarsand when... (3)
-> + Whitespace problem when return... (5)
-> + Problem with namespace prefix ... (5)
-> - Sending via SFTP returns unexp... (1)
-> + Query and Sftp clent (4)
-> + xquery and try - catch (3)
-> + Query + ddtek:http-post optio... (5)
-> + Example files referenced in do... (3)
-> + Automatic Error Detection and ... (3)
-> + Working with result of ddtek:h... (2)
-- [1-20] [21-40] [41-60] Next
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
john jenkinsonSubject: XSLT sorting parent nodes by multiple child nodes
Author: john jenkinson
Date: 08 May 2007 03:55 PM
Hi

I am trying to sort a xml file using xslt in order to display the lowest RoomPrice for each Hotel node in order i.e if a Hotel has a RoomPrice of £49 and another RoomPrice of £59 (same Hotel) it should then put the one with £49 first. There are also mulitple Hotels and these should be sorted on lowest RoomPrice within each Hotel.
If anyone could help it would be of great benefit to me.

Here is my XML :

<Hotel h="1">
<HotelCode>LGWARO</HotelCode>
<HotelName>Arora International</HotelName>
<StarRating>4</StarRating>
<OnAirport>N</OnAirport>
<NonSmokingRooms>N</NonSmokingRooms>
<Transfer24Hour>N</Transfer24Hour>
<CarParkOnSite>Y</CarParkOnSite>
<RequestFlags>
<Registration>N</Registration>
<CarMake>N</CarMake>
<CarModel>N</CarModel>
<CarColour>N</CarColour>
<CarPickupDate>N</CarPickupDate>
<CarDropoffTime>N</CarDropoffTime>
<CarPickupTime>N</CarPickupTime>
<CreditCard>N</CreditCard>
<ReturnFlight>N</ReturnFlight>
<Terminal>N</Terminal>
</RequestFlags>
<RoomType t="1">
<Room r="1">
<RoomCode>DBL</RoomCode>
<BoardBasis>RO</BoardBasis>
<Upgrade>N</Upgrade>
<Price p="1">
<ParkingDays>0</ParkingDays>
<RoomPrice>354.00</RoomPrice>
</Price>
<Price p="2">
<ParkingDays>8</ParkingDays>
<RoomPrice>384.00</RoomPrice>
</Price>
<Price p="3">
<ParkingDays>15</ParkingDays>
<RoomPrice>410.00</RoomPrice>
</Price>
</Room>
<Room r="2">
<RoomCode>TWN</RoomCode>
<BoardBasis>RO</BoardBasis>
<Upgrade>N</Upgrade>
<Price p="1">
<ParkingDays>0</ParkingDays>
<RoomPrice>354.00</RoomPrice>
</Price>
<Price p="2">
<ParkingDays>8</ParkingDays>
<RoomPrice>384.00</RoomPrice>
</Price>
<Price p="3">
<ParkingDays>15</ParkingDays>
<RoomPrice>410.00</RoomPrice>
</Price>
</Room>
</RoomType>
</Hotel>
<Hotel h="2">
<HotelCode>LGWARP</HotelCode>
<HotelName>Arora International (Sec-Pkg)</HotelName>
<StarRating>4</StarRating>
<OnAirport>N</OnAirport>
<NonSmokingRooms>N</NonSmokingRooms>
<Transfer24Hour>N</Transfer24Hour>
<CarParkOnSite>N</CarParkOnSite>
<RequestFlags>
<Registration>N</Registration>
<CarMake>N</CarMake>
<CarModel>N</CarModel>
<CarColour>N</CarColour>
<CarPickupDate>N</CarPickupDate>
<CarDropoffTime>N</CarDropoffTime>
<CarPickupTime>N</CarPickupTime>
<CreditCard>N</CreditCard>
<ReturnFlight>N</ReturnFlight>
<Terminal>N</Terminal>
</RequestFlags>
<RoomType t="1">
<Room r="1">
<RoomCode>DBL</RoomCode>
<BoardBasis>RO</BoardBasis>
<Upgrade>N</Upgrade>
<Price p="1">
<ParkingDays>8</ParkingDays>
<RoomPrice>630.00</RoomPrice>
</Price>
<Price p="2">
<ParkingDays>15</ParkingDays>
<RoomPrice>654.00</RoomPrice>
</Price>
</Room>
<Room r="2">
<RoomCode>TWN</RoomCode>
<BoardBasis>RO</BoardBasis>
<Upgrade>N</Upgrade>
<Price p="1">
<ParkingDays>8</ParkingDays>
<RoomPrice>630.00</RoomPrice>
</Price>
<Price p="2">
<ParkingDays>15</ParkingDays>
<RoomPrice>654.00</RoomPrice>
</Price>
</Room>
</RoomType>
</Hotel>
<Hotel h="3">
<HotelCode>LGWHIL</HotelCode>
<HotelName>Hilton</HotelName>
<StarRating>4</StarRating>
<OnAirport>Y</OnAirport>
<NonSmokingRooms>N</NonSmokingRooms>
<Transfer24Hour>Y</Transfer24Hour>
<CarParkOnSite>N</CarParkOnSite>
<RequestFlags>
<Registration>Y</Registration>
<CarMake>N</CarMake>
<CarModel>N</CarModel>
<CarColour>N</CarColour>
<CarPickupDate>Y</CarPickupDate>
<CarDropoffTime>Y</CarDropoffTime>
<CarPickupTime>Y</CarPickupTime>
<CreditCard>N</CreditCard>
<ReturnFlight>N</ReturnFlight>
<Terminal>Y</Terminal>
</RequestFlags>
<RoomType t="1">
<Room r="1">
<RoomCode>DBL</RoomCode>
<BoardBasis>RO</BoardBasis>
<Upgrade>Y</Upgrade>
<Price p="1">
<ParkingDays>0</ParkingDays>
<RoomPrice>810.78</RoomPrice>
</Price>
<Price p="2">
<ParkingDays>8</ParkingDays>
<RoomPrice>834.65</RoomPrice>
</Price>
<Price p="3">
<ParkingDays>15</ParkingDays>
<RoomPrice>864.65</RoomPrice>
</Price>
</Room>
<Room r="2">
<RoomCode>TWN</RoomCode>
<BoardBasis>RO</BoardBasis>
<Upgrade>Y</Upgrade>
<Price p="1">
<ParkingDays>0</ParkingDays>
<RoomPrice>810.78</RoomPrice>
</Price>
<Price p="2">
<ParkingDays>8</ParkingDays>
<RoomPrice>834.65</RoomPrice>
</Price>
<Price p="3">
<ParkingDays>15</ParkingDays>
<RoomPrice>864.65</RoomPrice>
</Price>
</Room>
</RoomType>
</Hotel>

Cheers

John
Posttop
Tony LavinioSubject: XSLT sorting parent nodes by multiple child nodes
Author: Tony Lavinio
Date: 09 May 2007 09:10 AM
1. Please post in only one forum.

2. Please don't post XSLT questions in the XQuery forum.

3. Remember that this is the free support forum for Stylus Studio
users. If you use the same email address to register here that you
did to register Stylus Studio, you are automatically recognized.
But since you did not, we do got give priority to your requests. If
you are a current user, when you make your request please state the
specific build of Stylus Studio that you are using.
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.