Multi-level Nested Array about aspjson HOT 6 CLOSED

Hi.

You can use the parse method to let the tools do the work for you:

Dim geometry, coordinates
Set geometry = new JSONObject
Set coordinates = new JSONObject
coordinates.parse(arrayDB) ' coordinates here will have a "data" property with your parsed jsonArray object

geometry.Add "type", "Polygon"
geometry.Add "coordinates", coordinates("data")

You could also set coordinates to the result of the parse:

'...
Set coordinates = new JSONObject
Set coordinates = coordinates.parse(arrayDB) ' coordinates here will be your parsed jsonArray object

geometry.Add "type", "Polygon"
geometry.Add "coordinates", coordinates

This two solutions would output the following when the serialize() or write() methods are called:

{"type":"Polygon","coordinates":[[[14.88,39.31],[14.88,39.31]]]}

from aspjson.

@rcdmk Using your example above, the result only produces ONE item from the array

[14.88,39.31]

{"type":"Polygon","coordinates":[14.88,39.31]}

from aspjson.

Mmmm...
I will need to take a look at this.

It must have worked the way I've showed you above.

I'll do some tests to find out what is going wrong.

from aspjson.

This is a real bug with the code.

I'll fix this as soon as possible.

In the meantime you can overcome this by wrapping the value in an object before parsing:

arrayDB = "{""value"":""[[[14.88,39.31],[14.88,39.31]]]""}"

coordinates.parse(arrayDB)

geometry.Add "coordinates", coordinates("value")

from aspjson.

@rcdmk The 3.5.1 update broke the following json parsing:

I will try to figure out why it is breaking. I reverted back to 3.5.0 and it is working

[[-117.215253710747,32.7973127662131],[-117.215039134026,32.7973623683555],[-117.21399307251,32.7971278852568],[-117.213585376739,32.7971639596199],[-117.212598323822,32.7973533497862],[-117.212115526199,32.7973804054914],[-117.212147712708,32.7970782829836]]

from aspjson.

Hum... This is strange...

I've tried a small test and it does work:

test = "[[-117.215253710747,32.7973127662131],[-117.215039134026,32.7973623683555],[-117.21399307251,32.7971278852568],[-117.213585376739,32.7971639596199],[-117.212598323822,32.7973533497862],[-117.212115526199,32.7973804054914],[-117.212147712708,32.7970782829836]]"

set json = new jsonObject

set arr = json.parse(test)

arr.write

Outputs:

[[-117.215253710747,32.7973127662131],[-117.215039134026,32.7973623683555],[-117.21399307251,32.7971278852568],[-117.213585376739,32.7971639596199],[-117.212598323822,32.7973533497862],[-117.212115526199,32.7973804054914],[-117.212147712708,32.7970782829836]]

Can you test this on your setup, please?

If you still have problems, please, post the smallest portion of code to reproduce the error.

from aspjson.