.Hello Tony and all,
I am trying to work out using last version of JqGrid 4.3.1 under IIS and Microsoft SQL Server platform using PHP+Javascript and I created a grid correctly. Just when I click to add record and I insert data, once I click to Submit using Firebug I get a POST successful with OK 200ms but it doesn't save anything and I see in XML tab response this kind of error:
|
1 |
XML Parsing Error: no element found Location: moz-nullprincipal:{...} Line Number 1, Column 1: |
What could be?
The piece of js code to manage the grid is:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
<div class="sfcode"><br /> jQuery(document).ready(function(){<br /> jQuery("#userstable").jqGrid({<br /> url:"load_datatable.php?table_name=users&fact=add",<br /> datatype: 'json',<br /> colNames:['ID','Last Name','First Name','Account','Password'],<br /> colModel:[<br /> {name:'ID',index:'ID',width:1,editable:false,hidden:true},<br /> {name:'Last_Name',index:'Last_Name',width:150,editable:true,editoptions:{readonly:false,size:40}},<br /> {name:'First_Name',index:'First_Name',width:150,editable:true,editoptions:{readonly:false,size:40}},<br /> {name:'Account',index:'Account',width:120,editable:true,editoptions:{readonly:false,size:40}},<br /> {name:'Password',index:'Password',width:120,editable:true,editoptions:{readonly:false,size:40}},<br /> ],<br /> rowNum:10,<br /> rowList:[10,20,30],<br /> loadonce:false,<br /> pager: '#pagerusers',<br /> emptyrecords: 'No users found',<br /> sortname: 'Last_Name',<br /> viewrecords: true,<br /> sortorder: "desc",<br /> caption:"Users",<br /> editurl:"edit_datatable.php?table_name=users&fact=add",<br /> shrinkToFit: false // autowidth: true,<br /> }).navGrid('#pagerusers',{<br /> edit:true,edittext:'Edit',edittitle:'Edit selected user...',<br /> add:true,addtext:'Add',addtitle:'Add new user...',<br /> del:true,deltext:'Remove',deltitle:'Remove selected user...',<br /> search:true,searchtext:'Find',searchtitle:'Find user...',<br /> refresh:true,refreshtext:'Reload',refreshtitle:'Reload users...'<br /> },<br /> {addfunc:function(){jQuery('#userstable').editGridRow("new",{height:180,width:400,reloadAfterSubmit:true,closeOnEscape:true});},<br /> editfunc:function(){var rowids=jQuery('#userstable').jqGrid('getCol','ID',false);var idsel=jQuery('#userstable').jqGrid('getGridParam','selrow');var id=rowids[idsel];jQuery('#userstable').editGridRow(idsel,{height:180,width:250,url:"edit_datatable.php?table_name=users&fact=edit&id="+id,reloadAfterSubmit:true,closeOnEscape:true});},<br /> delfunc:function(){var rowids=jQuery('#userstable').jqGrid('getCol','ID',false);var idsel=jQuery('#userstable').jqGrid('getGridParam','selrow');var id=rowids[idsel];jQuery('#userstable').delGridRow(idsel,{url:"edit_datatable.php?table_name=users&fact=del&id="+id,reloadAfterSubmit:true,closeOnEscape:true});},refresh:true,search:true}, //options<br /> {height:180,width:400,reloadAfterSubmit:true,bSubmit:'Save',recreateForm:true}, // edit options<br /> {height:180,width:400,reloadAfterSubmit:true,bSubmit:'Save',recreateForm:true}, // add options<br /> {reloadAfterSubmit:true}, // del options<br /> {});<br /> });<br /> </div> |
which it looks like just ok.
Any trick is appreciate.. thanks
Luigi
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top
