Okay, finally figured this out: To make this work in CF8 (w/ chf4
applied), I had to change the returnformat to "plain", rather than
"json". Otherwise it escaped all the quotes used to construct the
JSON. This does not happen in CF9.

Searched and searched for this on the web to no avail - hopefully this
will save someone else some time.

Cheers,
Kris


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

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:340326
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reply via email to