Hi folks,
Was reworking a function today to use serializejson instead of
building the json myself. Love this functionality. Unfortunately, I've
run into a snag when I pushed this over to a CF8 box where it must
run. The double-quotes on elements in the JSON returned are escaped
when run from the CF8 box, but are not escaped (the desired format)
when run from CF9.
I checked hotfixes, and updated the CF8 box to chf4, which includes
the functionality for returnformat=json.
CF9 Format:
{"COLUMNS":["CREATE_DT","ID","CMS_ID","NAME"],"DATA":[["December, 30
2010 19:16:31",32,"KJ301220101413",null],["December, 30 2010
18:33:45",31,"KJ301220101413",null]]}
CF8 Format:
"{\"COLUMNS\":[\"CREATE_DT\",\"ID\",\"CMS_ID\",\"NAME\"],\"DATA\":[[\"December,
30 2010 19:16:31\",32,\"KJ301220101413\",null],[\"December, 30 2010
18:33:45\",31,\"KJ301220101413\",null]]}"
Anyone have any experience with this? Know the fix?
Cheers,
Kris
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340323
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
