Thread: Sorting?
View Single Post
  #1 (permalink)  
Old October 27th, 2003, 10:23 AM
pbernardo pbernardo is offline
Authorized User
 
Join Date: Oct 2003
Location: , , .
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default Sorting?

I'm new to XSLT so please bear with me.

I have XML looking like this.

<Event>
    <AirDateTime>10/24/2003</AirDateTime>
    <ArriveTime>10:00 AM</ArriveTime>
    <BeginTime>10:30 AM</BeginTime>
        <Location>House</Location>
    <State>FL</State>
    <Street>123 Biscanye Blvd.</Street>
        <City>Miami</City>
    <TimeZone>EST</TimeZone>
</Event>
<Event>
    <AirDateTime>10/24/2003</AirDateTime>
    <ArriveTime>10:30 AM</ArriveTime>
    <BeginTime>11:00 AM</BeginTime>
        <Location>Apartment</Location>
    <State>FL</State>
    <Street>123 Biscanye Blvd.</Street>
        <City>Miami</City>
    <TimeZone>EST</TimeZone>
</Event>
<Event>
    <AirDateTime>10/25/2003</AirDateTime>
    <ArriveTime>10:30 AM</ArriveTime>
    <BeginTime>11:00 AM</BeginTime>
        <Location>House</Location>
    <State>FL</State>
    <Street>123 Biscanye Blvd.</Street>
        <City>Miami</City>
    <TimeZone>EST</TimeZone>
</Event>
What I would like to do is match all Events that have the same AirDateTime and display the date with the location. Then go through again and show each with more detail. Below I have included a sample of what I'm looking for.

10/24/2003 - House
10/24/2003 - Apartment

10/25/2003 - House
~~~~~~~~~~~~~~~~~~~~~~~~~
10/24/2003 - 10:00AM
House
123 Biscanye Blvd.
Miami, FL

10/24/2003 - 10:30AM
Apartment
123 Biscanye Blvd.
Miami, FL

10/25/2003 - 10:00AM
House
123 Biscanye Blvd.
Miami, FL


Any help is appreciated, Please keep in mind that the XML events will not be presorted, dates will be jumbled up.

Thank you
Pete

Reply With Quote