Classic ASP

XML Sort by Content

Demonstrates the SortByContent method.

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

<root>
    <fruits>
        <apples>
            <apple>fuji</apple>
            <apple>gala</apple>
            <apple>granny smith</apple>
            <apple>honeycrisp</apple>
            <apple>mcintosh</apple>
        </apples>
        <fruit>banana</fruit>
        <fruit>blackberry</fruit>
        <fruit>blueberry</fruit>
        <fruit>orange</fruit>
        <fruit>pear</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/fruitSort2.xml
success = xml.LoadXmlFile("fruitSort2.xml")
If (success <> 1) Then
    Response.Write "<pre>" & Server.HTMLEncode( xml.LastErrorText) & "</pre>"
    Response.End
End If

' Sort the direct children under the "fruits" node by tag:
' xSortRoot is a Chilkat.Xml
Set xSortRoot = xml.FindChild("fruits")

' Sort in ascending order.
bAscending = 1
xSortRoot.SortByContent bAscending

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

' Note:  The "apples" node contains child nodes, but its 
' text content is 0-length (empty).  Therefore, when sorting in
' ascending order, it will be positioned before the direct
' children containing non-empty content.

' <root>
'     <fruits>
'         <apples>
'             <apple>granny smith</apple>
'             <apple>gala</apple>
'             <apple>fuji</apple>
'             <apple>mcintosh</apple>
'             <apple>honeycrisp</apple>
'         </apples>
'         <fruit>banana</fruit>
'         <fruit>blackberry</fruit>
'         <fruit>blueberry</fruit>
'         <fruit>orange</fruit>
'         <fruit>pear</fruit>
'     </fruits>
' </root>

' Sort the direct children under the "apples" node:
success = xSortRoot.FindChild2("apples")

xSortRoot.SortByContent bAscending
Response.Write "<pre>" & Server.HTMLEncode( xml.GetXml()) & "</pre>"

' <root>
'     <fruits>
'         <apples>
'             <apple>fuji</apple>
'             <apple>gala</apple>
'             <apple>granny smith</apple>
'             <apple>honeycrisp</apple>
'             <apple>mcintosh</apple>
'         </apples>
'         <fruit>banana</fruit>
'         <fruit>blackberry</fruit>
'         <fruit>blueberry</fruit>
'         <fruit>orange</fruit>
'         <fruit>pear</fruit>
'     </fruits>
' </root>


%>
</body>
</html>