[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

sorting by date

Subject: sorting by date
From: "Daniel Newman" <daniel.newman@xxxxxxxxxxx>
Date: Tue, 24 Jul 2001 13:15:31 +0100
sorting by date
hello again,

I've got a little problem that I've just spotted, and hoped you might help
with?

I need to order my results in date order, except the date data is in an odd
format.

<RetrieveTransactionHistory2RSResponse>
    <Result>0</Result>
    <NoOfItems>10</NoOfItems>
        <Items>
            <Item id="1">
                <Date>02111998</Date>
            </Item>
            <Item id="2">
                <Date>07071999</Date>
            </Item>
            <Item id="3">
                <Date>22121999</Date>
            </Item>
            <Item id="4">
                <Date>02111998</Date>
            </Item>
            <Item id="5">
                <Date>02111998</Date>
            </Item>
            <Item id="6">
                <Date>02111998</Date>
            </Item>
            <Item id="7">
                <Date>02111998</Date>
            </Item>
            <Item id="8">
                <Date>17042000</Date>
            </Item>
            <Item id="9">
                <Date>11011999</Date>
            </Item>
            <Item id="10">
                <Date>10071998</Date>
            </Item>
    </Items>
</RetrieveTransactionHistory2RSResponse>


So is it at all possible for me to sort these results into descending date
order?

Not to actually convert the XML, but to read from the XML in this order.

<RetrieveTransactionHistory2RSResponse>
    <Result>0</Result>
    <NoOfItems>10</NoOfItems>
        <Items>
            <Item id="8">
                <Date>17042000</Date>
            </Item>
            <Item id="3">
                <Date>22121999</Date>
            </Item>
            <Item id="2">
                <Date>07071999</Date>
            </Item>
            <Item id="9">
                <Date>11011999</Date>
            </Item>
            <Item id="1">
                <Date>02111998</Date>
            </Item>
            <Item id="4">
                <Date>02111998</Date>
            </Item>
            <Item id="5">
                <Date>02111998</Date>
            </Item>
            <Item id="6">
                <Date>02111998</Date>
            </Item>
            <Item id="7">
                <Date>02111998</Date>
            </Item>
            <Item id="10">
                <Date>10071998</Date>
            </Item>
    </Items>
</RetrieveTransactionHistory2RSResponse>

Thanks if you know,

Daniel.

Bis-Web Ltd.
Tel: 01993 880614
Fax: 01993 881625

****************************************************************************
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the
material from any computer.
****************************************************************************


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.