Updating a result in JSON with a dynamic variable name

Question

I need to update a value in my JSON.

My JSON result looks like this:

results = {"ROWCOUNT":50,"COLUMNS":["PERSONID","NAME"],"DATA":{"PERSONID":["42","43","44"], "NAME":["JOE","TOM","JANE"]}
resultData = results.DATA

In the below code I am looping over the result set and attempting to update a value at a position. I believe it is failing because I am not using dynamic variables correctly.

var columnName = "NAME";

for(i=0; i < results.ROWCOUNT; i++ ){
 resultData.columnName[i] = "foo" // failing here due to "columnName" being dynamic.
}

This is a JavaScript object, not JSON. – Felix Kling Jul 23 '12 at 01:25 — Felix Kling, Jul 23 '12 at 01:25

score 2 · Answer 1 · edited Jul 23 '12 at 01:41

2

Figured it out.. You have to use array syntax

resultData[columName][i]

edited Jul 23 '12 at 01:41

ThinkingStiff

64,767
30
146
239

answered Jul 23 '12 at 01:28

Jason Wells

887
6
16
33

Updating a result in JSON with a dynamic variable name

1 Answers1