3 Replies Latest reply on Dec 13, 2010 12:59 PM by Avatar

    coldfusion json truncates leading zeroes

    funandlearning333 Level 1

      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?