[jQuery] Turning JSON-formatted AJAX data into data usable by ColdFusion
Ok, so I'm at the point in using jQuery AJAX where I'm now
returning complicated data of queries (multiple) and bits of
data for use back on the calling page.
In my CFC's, I use the returnFormat="json" to send data back
properly json-formatted.
However, now, I need to know how to get that json data back
into a form that I can use with my CF knowledge. Such as
looping queries, referring to data by "myQuery.name", etc.
In other words, I want to get that json data back into my
comfort zone.
I need to know what technique to look at. I've looked over
many resources and they all seem to offer a little different
approach. I have no experience with which to evaluate these
approaches. CFSON seems to be the most likely candidate.
So, to get this json data (below--from one of my CFC functions),
back into ColdFusion, what does everyone suggest?
Thanks for *any* guidance!
Rick
Here's the data mentioned above--does using CFJSON translate this
back into "ColdFusion format" without me having to write a bunch
of js code to loop the code etc, to translate it?
{"MONTH":2,"QGETSCHEDULE":{"COLUMNS":["DUTY_ID","DATE","AM_PM","AGENT_ID","POSITION","FIRST_NAME","L
AST_NAME"
],"DATA":[[1677,"February, 28 2009 00:00:00","am",18,"primary","Mary","Fail"],[1678,"February, 28
2009
00:00:00","am",19,"alternate","Rebecca","Nottingham"],[1679,"February, 28 2009
00:00:00","pm",20,"primary"
,"Renea","Camper"],[1680,"February, 28 2009
00:00:00","pm",21,"alternate","Verjuana","Underwood"]]},"MESSAGE"
:"Success","YEAR":2009,"SELECTED_DATE":"2009-02-01","QGETDUTYDATES":{"COLUMNS":["DATE"],"DATA":[["Fe
bruary
, 01 2009 00:00:00"],["February, 02 2009 00:00:00"],["February, 03 2009 00:00:00"],["February, 04
2009
00:00:00"],["February, 05 2009 00:00:00"],["February, 06 2009 00:00:00"],["February, 07 2009
00:00:00"
],["February, 08 2009 00:00:00"],["February, 09 2009 00:00:00"],["February, 10 2009
00:00:00"],["February
, 11 2009 00:00:00"],["February, 12 2009 00:00:00"],["February, 13 2009 00:00:00"],["February, 14
2009
00:00:00"],["February, 15 2009 00:00:00"],["February, 16 2009 00:00:00"],["February, 17 2009
00:00:00"
],["February, 18 2009 00:00:00"],["February, 19 2009 00:00:00"],["February, 20 2009
00:00:00"],["February
, 21 2009 00:00:00"],["February, 22 2009 00:00:00"],["February, 23 2009 00:00:00"],["February, 24
2009
00:00:00"],["February, 25 2009 00:00:00"],["February, 26 2009 00:00:00"],["February, 27 2009
00:00:00"
],["February, 28 2009 00:00:00"]]}}