jQuery Grid Plugin - jqGrid - Topic: Trying to edit and save a cell with empty content http://www.trirand.com/blog/?page_id=393/help/trying-to-edit-and-save-a-cell-with-empty-content Simple:Press Version 5.7.5.3 gseroul on Trying to edit and save a cell with empty content http://www.trirand.com/blog/?page_id=393/help/trying-to-edit-and-save-a-cell-with-empty-content#p18290 Help http://www.trirand.com/blog/?page_id=393/help/trying-to-edit-and-save-a-cell-with-empty-content#p18290 Hi Tony,

Unfortunately this correction may introduced a bug : I have in my grid some empty cell (date). But when I edit a row and save the empty cell value is not '' but ' ' => then saving this as a date give me an error in my DB. If a field is null we should keep it at null no ?

]]> Wed, 30 Jun 2010 14:52:07 +0300 tony on Trying to edit and save a cell with empty content http://www.trirand.com/blog/?page_id=393/help/trying-to-edit-and-save-a-cell-with-empty-content#p8876 Help http://www.trirand.com/blog/?page_id=393/help/trying-to-edit-and-save-a-cell-with-empty-content#p8876 Hello,

Thanks I have fixed this bug in cellEdit in gitHub.

Regards

Tony

]]> Fri, 21 Aug 2009 03:00:52 +0300 nisse on Trying to edit and save a cell with empty content http://www.trirand.com/blog/?page_id=393/help/trying-to-edit-and-save-a-cell-with-empty-content#p8819 Help http://www.trirand.com/blog/?page_id=393/help/trying-to-edit-and-save-a-cell-with-empty-content#p8819 Thank you!

Your solution worked out fine. But I used:

if (value == “” ) return “ ”; 

instead of

if (value == “” ) return “ ”; 

Regards

Nisse

]]> Wed, 19 Aug 2009 14:22:29 +0300 tony on Trying to edit and save a cell with empty content http://www.trirand.com/blog/?page_id=393/help/trying-to-edit-and-save-a-cell-with-empty-content#p8796 Help http://www.trirand.com/blog/?page_id=393/help/trying-to-edit-and-save-a-cell-with-empty-content#p8796 Hello,

This is because we use setCell to store the value and if it is empty we do not set the new value.

Now maybe you should use beforeSaveCell to do this - something like

beforeSaveCell : function (rowid,colName, value, iRow,iCol) {

if (value == "" ) return " ";

else return value;

}

Also some other note - if you save the value to the server check if you handle empty values.

Best Regards

Tony

]]> Wed, 19 Aug 2009 07:00:59 +0300 nisse on Trying to edit and save a cell with empty content http://www.trirand.com/blog/?page_id=393/help/trying-to-edit-and-save-a-cell-with-empty-content#p8763 Help http://www.trirand.com/blog/?page_id=393/help/trying-to-edit-and-save-a-cell-with-empty-content#p8763 Hello!

I have tried searching for this problem on this forum and inside the documentation, but have not found an answer for the following:

I am using jqgrid and the cellEdit feature. And it works quite well.

Now, I am wondering if the following is a default configuration or a bug:

Whenever I edit a cell that loads with a value and change it to nothing, it comes back to the previous value!

Example

Before: "test"
Change to: "test2"
Result after refresh: "test2"
That is, as expected

but the following is not what I want

Before: "test"
Change to: "" <-- nothing
Result after refresh: "test"
That is, not what I expected or want. I would like the cell to be empty!

I have tried the following:

-----------------------------------------
afterSaveCell:function(rowid,fieldname,value,iRow,iCol){
  if(value == '') {
  alert("empty!");
  jQuery("#list").setCell(rowid,fieldname,"&nbsp;");
   
  }
},
-----------------------------------------

I have also tried, undefined or null, but still does not work

And the alert works when I leave the cell empty, so it seems like it is intercepted correctly, but when I refresh the previous content of the cell comes back!!

How do I change that?

Thanks

nisse

]]> Wed, 19 Aug 2009 01:22:00 +0300