QueryToJSON result formating

[Mario]

Right now I'm getting:

[{"TempMedia":2123.50964974982,"aDate":1},{"TempMedia":2089.43531093638,"aDate":2},{"TempMedia":2017.01428571429,"aDate":3},{"TempMedia":2073.51851851852,"aDate":4},{"TempMedia":2130.05801305294,"aDate":5},{"TempMedia":2118.83435582822,"aDate":6},{"TempMedia":2041.16780045351,"aDate":7},{"TempMedia":1995.36926147705,"aDate":8},{"TempMedia":2048.29510703364,"aDate":9},{"TempMedia":2099.21413121846,"aDate":10},{"TempMedia":2087.9415954416,"aDate":11},{"TempMedia":2059.38091769847,"aDate":12},{"TempMedia":2055.66220238095,"aDate":13},{"TempMedia":2056.71783625731,"aDate":14},{"TempMedia":2053.73744619799,"aDate":15},{"TempMedia":1978.57142857143,"aDate":16},{"TempMedia":2035.56899004267,"aDate":17},{"TempMedia":1951.6678700361,"aDate":18},{"TempMedia":1963.21981424149,"aDate":19},{"TempMedia":2042.48091603053,"aDate":20},{"TempMedia":2070.39705882353,"aDate":21},{"TempMedia":2028.07547169811,"aDate":22},{"TempMedia":2081.15796997856,"aDate":23},{"TempMedia":2065.30410183876,"aDate":24},{"TempMedia":2045.22334293948,"aDate":25},{"TempMedia":2045.77304964539,"aDate":26},{"TempMedia":2050.17692852088,"aDate":27},{"TempMedia":2053.20028510335,"aDate":28},{"TempMedia":2032.11882605583,"aDate":29},{"TempMedia":2025.12747875354,"aDate":30},{"TempMedia":1979.47368421053,"aDate":31}]

Using:

SQL = "SELECT AVG(Q12) as TempMedia, DatePart(""d"",Sampledate) as aDate FROM Temperature WHERE SampleDate BETWEEN #" & StartDTime & "# AND #" & FinishDTime & "# " & " GROUP BY DatePart(""d"",Sampledate)"

jsa=QueryToJSON(oConn, sql).jsString

How can I get this?:

[{

    "name": "aDate",

    "data": ["1", "2", "3", "4", "5"...]

}, {

    "name": "TempMedia",

    "data": ["2123.50964974982", "2089.43531093638", "2017.01428571429", "2073.51851851852", "2130.05801305294"...]

}]

[Mario]

Just in case...

 

I need this to pass the json data with HighCharts