Dumb question. But you are doing something like this: <cfreturn serializejson(data)>
but _also_ adding returnFormat=json? If so - you are double serializing the JSON. On Thu, Dec 30, 2010 at 8:09 PM, Kris Jones <[email protected]> wrote: > > 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:340327 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
