jQuery Grid Plugin - jqGrid

(Newbee… appologies)

I need a qualifier that is changed by the user for all loads, reloads, edit, add, and delete of the grid. I have set up a var MemNo globally and used sccessfully in load, reload, edit and add: specified as postData:{wmemno:MemNo} in load, reload apears to pick it up dynamically and correctly, beforeSubmit function(row){row.wmemno=MemNo;} on the navGrid edit options (works on add as well without specifying it specifically for add), and tried to do the same for delete and it is not working.

I have tried editData in the navigator options… did not seem to respond, and delData in the delete options… did not respond. I realized that the input to beforeSubmit on edit and add are an object to which I have added my property but for delete it is just the row id and not an object.

I attach the load function and ask: how do I pass the MemNo dynamically to the editurl so that I can qualify the delete sql statement by this number in addition to the row id?

Many Thanks for any help!!

  function loadSpGrid() {
      jQuery(”#spgrid”).jqGrid({
        url:'s007.jsp',
        postData: {wmemno:MemNo},
        editurl:'s008.jsp',
        datatype: 'json',
        mtype: 'GET',
        colNames:['Start','End','Service','Earnings','Eligible'],
        colModel :[
          {name:'sdate',index:'start_date',width:80,
                         editable:true,editrules:{required:true}},
          {name:'edate',index:'end_date',width:80,
                         editable:true,editrules:{required:true}},
          {name:'service',index:'service',width:60,align:'right',
                         editable:true,editrules:{required:true,number:true}},
          {name:'earnings',index:'earnings',width:80, align:'right',
                         editable:true,editrules:{required:true,number:true}},
          {name:'eservice',index:'eligible_service',width:70,align:'right',sortable:false,
                         editable:true,editrules:{required:true,number:true}} ],
        pager: jQuery('#pager'),
        rowNum:10,
        rowList:[10,20,30],
        height:210,
        sortname: 'start_date',
        sortorder: “asc”,
        viewrecords: true,
        imgpath: 'js/themes/sand/images',
        caption: 'Financial data',
        subGrid: true,
        subGridRowExpanded: function(subgrid_id, row_id) {
          var subgrid_table_id = subgrid_id + “_t”;
          var pager_id = “p_” + subgrid_table_id;
          jQuery(”#”+subgrid_id).html(”<table id='”+subgrid_table_id+”' class='scroll'></table><div id='”+pager_id+”' class='scroll'></div>”);
          jQuery(”#”+subgrid_table_id).jqGrid({
            url:”s010.jsp?q=2&id=”+row_id+”&wmemno=”+MemNo,
            editurl:”s011.jsp?wmemno=”+MemNo+”&wspno=”+row_id,
            datatype: “json”,
            colNames:['Plan','Member contr.','Employer contr.'],
            colModel: [
              {name:"plan",index:"1",width:40,key:true,
                editable:true,editrules:{required:true}},
              {name:"memcon",index:"2",width:100,align:"right",sortable:false,
                editable:true,editrules:{required:true,number:true}},
              {name:"empcon",index:"3",width:110,align:"right",sortable:false,
                editable:true,editrules:{number:true}}
            ],
            pager: pager_id,
            height: '100%',
            rowNum:10,
            imgpath: 'js/themes/sand/images',
            sortname: '1',
            sortorder: “asc”
          }).navGrid(”#”+pager_id,{search:false},
               {height:200,reloadAfterSubmit:false},
               {height:200}, //add options
               {reloadAfterSubmit:false}, //del options
               {} //search options
             );
        }
      }).navGrid('#pager',
          {search:false}, //options
          {height:200,reloadAfterSubmit:false,
             beforeSubmit:function(row){
               row.wmemno = MemNo;
               return true;
             } //works on add as well but not delete.
          }, //edit options
          {height:200}, //add options
          {reloadAfterSubmit:false,
             beforeSubmit:function(row){
               jQuery(”#spgrid”).setGridParam({delData:{wmemno:MemNo}});
               return true;
             }
          }, //del options
          {} //search options
          );
  }