serialize JSON with plus sign results in invalid JSON

Question

I'm working with data via an IBM MQ call where a 0 is returned as +0.0 when this is serialized by ColdFusion 10 (10,0,11,285437) it results in invalid JSON and cannot be deserialized.

stPolicy = { "prem": "+0.0" };
serializedData = serializeJSON(stPolicy);
writeDump(isJSON(serializedData));
writeDump(deserializeJSON(serializedData));

This outputs NO for isJSON and an error when trying to deserialize JSON parsing failure at character 9:'+' in {"prem":+0.0}.

I'm able to work around this by replacing all +0 to 0, but I'm guessing this is a bug in ColdFusion. Has anyone else had this issue and implemented a better fix?

Bug report filed: Bug #3632972

@Henry bug entered https://bugbase.adobe.com/index.cfm?event=bug&id=3632972 — Matt Busche, Sep 16 '13 at 17:36
Bloody hell... exactly when will all these bugs in ColdFusion's JSON handling end? I think they need to start from scratch & do it properly. Needless to say I will vote for this. It is broken on CF9 and CF10, btw. But works fine on Railo. And even OpenBD. — Adam Cameron, Sep 16 '13 at 18:11
I wonder if there is a CFC on github or somewhere that someone is working on? We need a single place to collaborate on this solution. — James A Mohler, Sep 16 '13 at 20:03
@JamesMohler Ben Nadel started a project here https://github.com/bennadel/JsonSerializer.cfc — Matt Busche, Sep 16 '13 at 21:00
How can there be so many bugs for such an expensive product? Srsly Adobe — Mike Causer, Dec 06 '13 at 15:13

score 1 · Accepted Answer · answered Dec 09 '13 at 18:27

Adobe has the bug listed as fixed in their bug database, but it has not yet been released. Here's the fix I came up with. Simply replace the +0 with 0

private string function serializeJSONFixCF10(required string serializedData) {
  return replace(arguments.serializedData,'+0','0','all');
}

serialize JSON with plus sign results in invalid JSON

1 Answers1