read JSON data received from the mysql

Question

I want to read data in the javascript which is received from the server in JSON format.

I've been using this a lot, but now it seems that I hit the wall with this example:

JSON

{
    "results": [
        {
            "MIN(jtable.HIT_VALUE)": "70.200000",
            "AVG(jtable.HIT_VALUE)": "124.4077234969",
            "MAX(jtable.HIT_VALUE)": "1854.620000"
        }
    ]

}

JAVASCRIPT

How to read these values?

I have tried this

response.results[i].MIN(jtable.HIT_VALUE)

and I'm getting this error:

TypeError: Object #<Object> has no method 'MIN'

Any ideas?

USE ALAISES IN MYSQL query like min(table.hitvalue) as minhitvalue — Pir Abdul, May 30 '13 at 09:16

score 4 · Accepted Answer · answered May 30 '13 at 09:16

4

MIN(jtable.HIT_VALUE) is the key and has to be used as such using the square bracket notation like

response.results[i]['MIN(jtable.HIT_VALUE)']

answered May 30 '13 at 09:16

shyam

9,134
4
29
44

score 1 · Answer 2 · answered May 30 '13 at 09:16

1

Use it as string:

response.results[i]['MIN(jtable.HIT_VALUE)']

answered May 30 '13 at 09:16

Rene Pot

24,681
7
68
92

score 1 · Answer 3 · answered May 30 '13 at 09:19

1

JavaScript interprets the call response.results[i].MIN(jtable.HIT_VALUE) as an attempt to call a nonexistent function MIN.

Consider using this:

response.results[i]["MIN(jtable.HIT_VALUE)"]

answered May 30 '13 at 09:19

potato25

186
5

read JSON data received from the mysql

3 Answers3