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"]]}}
