jQuery Grid Plugin - jqGrid - Topic: [ 3.8 - bug ] - Update table with a json string

jacquesh on [ 3.8 - bug ] - Update table with a json string

Sun, 03 Oct 2010 01:42:07 +0300

OK, I've add a cell, change the form of jsonstring ; but the problem still the same.

var mystr = '{"total": "1","page": "1","records": "1","rows" : [{"id":"1", "cell":["cell00711","cell00711","cell12","cell13","cell12","cell13"]}]}';

jQuery("#process_list")

.jqGrid("setGridParam", {datastr:mystr})

.trigger("reloadGrid");

Everything is OK via json(URL) but not with json(string)

Can you try to create a mini sample with a grid with new data when reloading with jsonstring as datatype.

I'd like to see a worked sample to be sure it's not a bug

Thanks !

OlegK on [ 3.8 - bug ] - Update table with a json string

Fri, 01 Oct 2010 11:46:05 +0300

Moveover jacquesh you have to follow JavaScript syntax. If a string has " and you use ans " for the string definition you should escape there: ". Better to define mystr using single quote as:

var mystr = '{"total": "1","page": "1","records": "1","rows" : [{"id":"1", "cell":["cell00711","cell12","cell13","cell12","cell13"]}]}';

Regards
Oleg

tony on [ 3.8 - bug ] - Update table with a json string

Fri, 01 Oct 2010 09:07:06 +0300

Hello,

In your case you have set 5 records, but your definition in colModel has 6 fields.

Pleadse read this carefully:

http://www.trirand.com/jqgridw.....#json_data

Regards

jacquesh on [ 3.8 - bug ] - Update table with a json string

Fri, 01 Oct 2010 01:49:43 +0300

my jqGrid definition

$("#process_list").jqGrid({

datatype: 'jsonstring',

datastr: mystr,

colNames:['id','Pid','PPid', 'Name', 'Path','CmdLine'],

colModel:[

{name:'id', index:'id', width:0},

{name:'pid', index:'pid', width:50},

{name:'ppid', index:'ppid', width:50},

{name:'name', index:'name', width:150},

{name:'path', index:'path', width:250},

{name:'cmdline',index:'cmdline',width:300}

sortname: 'pid',

viewrecords: true,

sortorder: "desc",

multiselect: false,

caption:"Process list"

});

jacquesh on [ 3.8 - bug ] - Update table with a json string

Fri, 01 Oct 2010 01:47:56 +0300

mystr = "{\"total\":\"1\",\"page\":\"1\",\"records\":\"1\",\"rows\" : [{\"id\":\"1\", \"cell\":[\"cell00711\",\"cell12\",\"cell13\",\"cell12\",\"cell13\"]}]}"

jQuery("#process_list")

.jqGrid("setGridParam", {datastr:mystr})

.trigger("reloadGrid");

same problem with a validated string.

Grid reload but with previous data.

another idea ?

OlegK on [ 3.8 - bug ] - Update table with a json string

Fri, 01 Oct 2010 00:43:00 +0300

Hello!

You used before wrong JSON data. Corresponds to http://www.json.org/ all strings must be double-quoited:

{
  "total": "1",
  "page": "1",
  "records": "1",
  "rows" : [
   {"id":"1", "cell":["cell00711","cell12","cell13","cell12","cell13"]}
  ]
}

So fix your code and it will work. I recommend you validate your JSON data in http://www.jsonlint.com/.

Regards
Oleg

jacquesh on [ 3.8 - bug ] - Update table with a json string

Thu, 30 Sep 2010 23:31:28 +0300

Hello,

mystr =

"{" +

"total: '1'," +

"page: '1'," +

"records: '1'," +

"rows : [" +

"{id:'1', cell:['cell00711','cell12','cell13','cell12','cell13']}" +

"]" +

"}";

jQuery("#process_list")

.jqGrid("setGridParam", {datastr:mystr})

.trigger("reloadGrid");

The grid load data with no problem from an URL.

I've set datastr: mystr and datatype: 'jsonstring'. No JS error but the grid don't load new data.

I've the same problem with 3.7.

Any Idea ?

Thanks for your help.