jQuery Grid Plugin - jqGrid - Topic: Leading zero of text field is dropped in grid http://www.trirand.com/blog/?page_id=393/help/leading-zero-of-text-field-is-dropped-in-grid Simple:Press Version 5.7.5.3 tony on Leading zero of text field is dropped in grid http://www.trirand.com/blog/?page_id=393/help/leading-zero-of-text-field-is-dropped-in-grid#p6870 Help http://www.trirand.com/blog/?page_id=393/help/leading-zero-of-text-field-is-dropped-in-grid#p6870 Hello,

Check the 3.5 beta.

Regards

Tony

]]> Mon, 25 May 2009 02:03:06 +0300 Jim P on Leading zero of text field is dropped in grid http://www.trirand.com/blog/?page_id=393/help/leading-zero-of-text-field-is-dropped-in-grid#p6809 Help http://www.trirand.com/blog/?page_id=393/help/leading-zero-of-text-field-is-dropped-in-grid#p6809 Tony,

I've followed the code through.  The json array before being fed to the grid:

<tr><td class="array" onClick="cfdump_toggleRow(this);" style="cursor:hand;" title="click to collapse">11</td>

body: <td> 099698071193253 </td></tr>

Firebug Data Return is: (Data field in question is in bold)

{"ROWS":[["ZT7947",1640872.0,"OFC1234","TACO BELL CORP.  ##OFC1234",
"15\\/05\\/2009 00:00:00","","ATTN
: KATHY WOOD:IRVINE, CA","TACO BELL CORPORATE",sue_somebody@tb.com,
"CATBC",9.9698071193253E13,"FEDERAL EXPRESS"],
["ZT7947A",1640924.0,"OFC1234","TACO BELL CORP.  ##OFC1234","06\\/04\\/2005 00:00:00","","ATTN
: KATHY WOOD:IRVINE, CA","TACO BELL CORPORATE","sue_somebody@tb.com","CATBC",7.06395013304E11,"FEDERAL
 EXPRESS"]],"PAGE":17.0,"TOTAL":17.0,"USERDATA":{"MSG":"Retreived 242 Records.","TYPE":"Success"},"RECORDS"
:242}
It looks like the grid thinks this is a number not a text field.
thanks,  Jim


 

]]> Wed, 20 May 2009 13:35:01 +0300 tony on Leading zero of text field is dropped in grid http://www.trirand.com/blog/?page_id=393/help/leading-zero-of-text-field-is-dropped-in-grid#p6806 Help http://www.trirand.com/blog/?page_id=393/help/leading-zero-of-text-field-is-dropped-in-grid#p6806 Hello,

This really is a problem. I have changed totally this behaviour in 3.5 beta, which will give you the right result. Also try the following

In case of  JSON try to enclose the value in string instead - i.e ... "mynumber" : "099698071193253"

Regards

Tony

]]> Wed, 20 May 2009 13:26:23 +0300 Jim P on Leading zero of text field is dropped in grid http://www.trirand.com/blog/?page_id=393/help/leading-zero-of-text-field-is-dropped-in-grid#p6758 Help http://www.trirand.com/blog/?page_id=393/help/leading-zero-of-text-field-is-dropped-in-grid#p6758 Tony,

This is VERY important for me.

The is colmodel definition of the column.

{name:'waybillnumber',index:'waybillnumber', align:"center",sorttype:"text"},

This is a shipping tracking number and often has a leading zero like this:

099698071193253

The number is correct in the database, but in the grid it show up as:

99698071193253

My grid data type is: datatype: 'json',

Why is this happening?

Thanks,  Jim 

]]> Tue, 19 May 2009 14:53:02 +0300