Classic ASP

XML Sort Records by Content

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>

Chilkat Classic ASP Downloads

Download Chilkat for Classic ASP

Classic ASP

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<%
success = 0

set xml = Server.CreateObject("Chilkat.Xml")

' The sample input XML is available at http://www.chilkatsoft.com/data/fruitRecordsSort.xml
success = xml.LoadXmlFile("fruitRecordsSort.xml")
If (success <> 1) Then
    Response.Write "<pre>" & Server.HTMLEncode( xml.LastErrorText) & "</pre>"
    Response.End
End If

' 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.
' xSortRoot is a Chilkat.Xml
Set xSortRoot = xml.FindChild("fruits")

' Sort by the "name" field in ascending order.
bAscending = 1
xSortRoot.SortRecordsByContent "name",bAscending

' Show the result:
Response.Write "<pre>" & Server.HTMLEncode( xml.GetXml()) & "</pre>"

' <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>


%>
</body>
</html>