Classic ASP
JSON: Access Array Values

Demonstrates how to access values in a JSON array.
Chilkat Classic ASP Downloads

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

set json = Server.CreateObject("Chilkat.JsonObject")

jsonStr = "{ ""id"": 1, ""name"": ""A green door"", ""tags"": [""home"", 22, ""green""], ""price"": 125 }"

success = json.Load(jsonStr)
If (success <> 1) Then
    Response.Write "<pre>" & Server.HTMLEncode( json.LastErrorText) & "</pre>"
    Response.End
End If

' Get the "tags" array, which contains "home", 22, "green"
' tagsArray is a Chilkat.JsonArray
Set tagsArray = json.ArrayOf("tags")
If (json.LastMethodSuccess = 0) Then
    Response.Write "<pre>" & Server.HTMLEncode( "tags member not found.") & "</pre>"
    Response.End
End If

' Get the value at each array index. 
' Output will be:
' [0] = home
' [0] as integer = 0
' [1] = 22
' [1] as integer = 22
' [2] = green
' [2] as integer = 0

arraySize = tagsArray.Size

For i = 0 To arraySize - 1

    sValue = tagsArray.StringAt(i)

    Response.Write "<pre>" & Server.HTMLEncode( "[" & i & "] = " & sValue) & "</pre>"

    iValue = tagsArray.IntAt(i)
    Response.Write "<pre>" & Server.HTMLEncode( "[" & i & "] as integer = " & iValue) & "</pre>"

Next

' Note: The StringAt method returns the value as a string regardless of the type.

' The IntAt method returns the value as an integer.  If the value does not convert to 
' an integer, then 0 is returned

%>
</body>
</html>