Forum

July 12th, 2025
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
cell edit problem
08/10/2009
11:15
Avatar
guidob
italy
New Member
Members
Forum Posts: 2
Member Since:
08/10/2009
sp_UserOfflineSmall Offline

Hi all,

I'm using 3.5.3 library version. I'm trying to use the cell edit option. I cannot able to save to DB in the cell edit mode, but it work fine if I click on the down-left grid corner and use the 'edit selected row' . In this case the data are saved to the DB . This is my celledit.js file:

jQuery("#celltbl").jqGrid({
    url:'server.php?q=2',
 datatype: "json",
        mtype: 'POST',
        cellsubmit: 'clientArray',
        cellEdit: true,
        cellurl: 'update.php',
        editurl: 'update.php',
    colNames:['Inv No','Date', 'Client', 'Amount','Tax','Total','Notes'],
    colModel:[
     {name:'id',index:'id', width:55},
     {name:'invdate',index:'invdate', width:90,editable:true},
     {name:'name',index:'name asc, invdate', width:100},
     {name:'amount',index:'amount', width:80, align:"right",editable:true,editrules:{number:true}},
     {name:'tax',index:'tax', width:80, align:"right",editable:true,editrules:{number:true}},  
     {name:'total',index:'total', width:80,align:"right"},  
     {name:'note',index:'note', width:150, sortable:false}  
    ],
    rowNum:10,
    rowList:[10,20,30],
    imgpath: gridimgpath,
    pager: jQuery('#pcelltbl'),
    sortname: 'id',
    viewrecords: true,
    sortorder: "asc",
    caption:"Cell Edit Example",
 forceFit : true,
 cellsubmit: 'clientArray',
 afterEditCell: function (id,name,val,iRow,iCol){
  if(name=='invdate') {
   jQuery("#"+iRow+"_invdate","#celltbl").datepicker({dateFormat:"yy-mm-dd"});
  }
 },
 afterSaveCell : function(rowid,name,val,iRow,iCol) {
  if(name == 'amount') {
   var taxval = jQuery("#celltbl").getCell(rowid,iCol+1);
   jQuery("#celltbl").setRowData(rowid,{total:parseFloat(val)+parseFloat(taxval)});
  }
  if(name == 'tax') {
   var amtval = jQuery("#celltbl").getCell(rowid,iCol-1);
   jQuery("#celltbl").setRowData(rowid,{total:parseFloat(val)+parseFloat(amtval)});
  }
 }
}).navGrid('#pgwidth',{edit:true,add:false,del:false});

Any help?

08/10/2009
13:25
Avatar
guidob
italy
New Member
Members
Forum Posts: 2
Member Since:
08/10/2009
sp_UserOfflineSmall Offline

OK, solved . I changed 'cellsubmit' to remote

Forum Timezone: Europe/Sofia

Most Users Ever Online: 994

Currently Online:
17 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information