My first thought would be prepend a char (perhaps a ~ or something) to the string that you later remove in order to preserve the zeros.
On Mon, Dec 13, 2010 at 10:52 AM, fun and learning <[email protected]>wrote: > > 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:340028 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
