jQuery Grid Plugin - jqGrid

Tony (sorry for the delay)

I want to do an inline edit.  I used the example rowedex5.html to start with.  I modified the colModel and the data var to use data that was like my application and then I was able to display and edit the grid using "local" data.  No problem.

Then I replaced the "local" data with a json call to my servlet and although the data comes back from the servlet OK, I can see it in the grid, I cannot edit it.  I am not sue what would be in the json data that would prevent editing but that seems to be the case.

Thanks

I actually have checked the code several times.  The ONLY thing that is different is the json string in my code that returns a literal string like this:

{total: “1″,page: “1″,records:” 3″,rows : [
 { absDate:"09/24/2008", begTime:"700", endTime:"1415"},
 { absDate:"09/25/2008", begTime:"700", endTime:"1415"},
 { absDate:"09/26/2008", begTime:"700", endTime:"1415"}
 ]
}

This is a string value. The grid will render but isn't editable.  If the json call returns this literal string:

 { absDate:"09/24/2008", begTime:"700", endTime:"1415"},
 { absDate:"09/25/2008", begTime:"700", endTime:"1415"},
 { absDate:"09/26/2008", begTime:"700", endTime:"1415"}

I get no grid rendered at all.

Can you think of a reason as to why that would be?  Does your PHP code return literal strings to your grids for parsing?

Tony,

I spent 3 or 4 hours on this while I was flying out to New York this morning and you came up with the same conclusion as I did.  I think the ID is problem and jqgrid cannot handle inline editing when you have taken the jsonreader option id:"0".  The colModel looks like this:

$("#workTimes").jqGrid({
   url: url,
   datatype: "json",
   colNames:['Absence Date', 'Begin Time', 'End Time'],
  colModel:[
   {name:'absDate',index:'absDate', width:120, sorttype:"date"},
   {name:'beginTime',index:'beginTime', width:100, editable: true,editoptions:{size:10}},
   {name:'endTime',index:'endTime', width:100, editable: true,editoptions:{size:10}}
   ], 
  rowNum:10,
  rowList:[10,20,30],
  imgpath: gridimgpath,
  pager: $('#pager'),
  sortname: 'absDate',
     onSelectRow: function(id){
        if(id && id!==lastsel3){
            $('#workTimes').restoreRow(lastsel3);
            $('#workTimes').editRow(id,true);
            lastsel3=id;
        }
    },
  sortorder: "desc",
  jsonReader: {repeatitems: false, cell: "", id: "0"},
  caption: "Employee Work Times"
  });

You can look at the data returned by json in my posts above. The absDate *was* set as the id originally.  The way I got this to work as to eliminate the id:"0" from the jsonreader in the colModel and then add an id number to the json data.  However, this is only a work around, what I need is a fix that will allow me to set the id and allow the inline editing.  Again, in the example above, if I set id:"absDate" in the colModel, the grid won't support inline editing.

What does the id:"0" signify? Page 32 of the manual says "And, it is possible to set the id as number." Is that all id:"0" does? Set the id to allow a numeric value?  I don't see an example that shows how you can set the id to another value using json data.  Is there an example of this?

So, I know the id is the problem.  How can I set the value so that I can use the absDate data as indicated in my earlier posts.

Thanks for the help.

Thanks again Tony.  I thought it might be a bug but, I am such a newbie that I figured it was something I was doing.

I tried both of your workarounds and neither worked.  When I used the key:true in the colModel, the grid rendered but couldn't be edited. When I used id:"Absence Date" the grid wouldn't render and I got a javascript error:

ts.p.colModel[idn] is undefined
http://localhost:8090/asaap3/scripts/js/grid.base.js
Line 626

So I will go back to using an id column in my json, but that isn't going to work in every situation.

I'd be happy to test your bug fix when you think it is ready to try.

Pete

Even with the change to id: “absDate” it still doesn't work.  In debug I see the data coming back in the "rowid" parameter.  So using the data earlier in this post as an example, if I clicked on the first row, debug would show "09/24/08" as the rowid parameter in the editRow function. But the function doesn't continue processing, it simply returns.

Perhaps the "/" in the date is creating an issue?

If I use a field called "id" in the json data and add a number to each row, I do get the correct data in the grid and it is editable.

Ideas?

Thanks again.

I guess I'll have to figure out to how to work around the problem.  I might be able to reformat the date but it is coming from flexjson and I don't know how much control I am going to have.

I appreciate the help.

Pete