Xbase++

XML Sort Records by Content

See more XML Examples

Demonstrates the SortRecordsByContent method.

The input XML, available at http://www.chilkatsoft.com/data/fruitRecordsSort.xml, is this:

<root>
    <fruits>
        <fruit>
            <name>apple</name>
            <color>red</color>
        </fruit>
        <fruit>
            <name>banana</name>
            <color>yellow</color>
        </fruit>
        <fruit>
            <name>blackberry</name>
            <color>purple</color>
        </fruit>
        <fruit>
            <name>blueberry</name>
            <color>blue</color>
        </fruit>
        <fruit>
            <name>orange</name>
            <color>orange</color>
        </fruit>
        <fruit>
            <name>pear</name>
            <color>green</color>
        </fruit>
    </fruits>
</root>

Xbase++

LOCAL nSuccess
LOCAL oXml
LOCAL oXSortRoot
LOCAL nBAscending

nSuccess := 0

oXml := CreateObject("Chilkat.Xml")

//  The sample input XML is available at http://www.chilkatsoft.com/data/fruitRecordsSort.xml
nSuccess := oXml:LoadXmlFile("fruitRecordsSort.xml")
IF (nSuccess != 1)
    ? oXml:LastErrorText
    oXml:destroy()
    RETURN
ENDIF

//  The "fruit" records are direct children of the "fruits" node.
//  Therefore, to sort the fruit records, the SortRecordsByContent
//  method must be called from the "fruits" node.
oXSortRoot := oXml:FindChild("fruits")

//  Sort by the "name" field in ascending order.
nBAscending := 1
oXSortRoot:SortRecordsByContent("name", nBAscending)

//  Show the result:
? oXml:GetXml()

//  <root>
//      <fruits>
//          <fruit>
//              <name>apple</name>
//              <color>red</color>
//          </fruit>
//          <fruit>
//              <name>banana</name>
//              <color>yellow</color>
//          </fruit>
//          <fruit>
//              <name>blackberry</name>
//              <color>purple</color>
//          </fruit>
//          <fruit>
//              <name>blueberry</name>
//              <color>blue</color>
//          </fruit>
//          <fruit>
//              <name>orange</name>
//              <color>orange</color>
//          </fruit>
//          <fruit>
//              <name>pear</name>
//              <color>green</color>
//          </fruit>
//      </fruits>
//  </root>

oXSortRoot:destroy()

oXml:destroy()