I've run into things like this aswell, like true/false false values being converted to no/yes via json. What I ended up doing was server side, I would do a find and replace for the strings I knew would have issues, like "true" and replace them with "^^%true", on the client side, I would then do the same thing to remove the extra characters from the JSON before decoding. This was the only way I could get the JSON down to the client in the original format..
Brook -----Original Message----- From: fun and learning [mailto:[email protected]] Sent: December-13-10 7:52 AM To: cf-talk Subject: coldfusion json truncates leading zeroes Hi All - I am using jquery jqgrid with Coldfusion. I have a cfc whose return format is JSON. I have a database column of type varchar, but it returns values which starts with zeroes. On displaying data, the leading zeroes are truncated. I verified in firebug, the JSON response itself is cutting off the leading zeroes. Any suggestions or thoughts on this? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:340029 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
