Coldfusion 11 & serializedJSON issue

Question

HiI wanted to upgrade our Coldfusion 10 to 11. We are using MongoDB as additional database, so we use Java MongoDB driver. And until this point everything is fine & everything works.All data to Mongo and from Mongo are in JSON format. Problem we have is that serialization changed in CF 11 what broke all queries.Here is an example:CF10: { "VAL1" : 0 , "VAL2" : { "$ne" : false} , "VAL3" : true , "VAL4" : { "$gt" : 5}} CF11: { "VAL1" : "0" , "VAL2" : { "$ne" : "false"} , "VAL3" : "true" , "VAL4" : { "$gt" : "5"}}Problem is that 0 != "0", true != "true", 5 != "5". Mongo can't compare string with int or bool (same issue with floats)When i put data to database have same issue. Something that was before integer or bool now is string.I found a way to make it work Javacast('int',value), Javacast('boolean',value) but changing it in every place in big project will take far too much time. Is there a way to make SerializeJson work like it worked before? Why it changes types now?

Carl Von Stetten · Answer

You might also look into using the custom serializer capabilities in ColdFusion 11, as the built-in serializer still isn't 100% fit for purpose (as you've seen). Here are a few useful links:

Adobe's docs on custom JSON serializers (particularly the very bottom of the page): ColdFusion Help | RESTful Web Services in ColdFusion‌

Adam Cameron's exploration of using the custom JSON serializer feature: Adam Cameron's Dev Blog: ColdFusion 11: custom serialisers. More questions than answers

Ben Nadel's alternative JSONSerializer CFC: JsonSerializer.cfc - A Data Serialization Utility For ColdFusion

That CFC on GitHub: bennadel/JsonSerializer.cfc · GitHub

Ray Camden's take on Ben Nadel's CFC: Implementing custom JSON serialization for your CFCs | Raymond Camden's Blog

HTH,

-Carl V.