Forum


Hello all,
I've been working on a CRUD and was wondering if anyone has seen simple examples using the 'url' parameter instead of 'editurl'?
I can get my grid to edit a row but to delete or add it always goes to the editurl property: 'editGrid.php'.
When I disable/remore 'editurl', I get the 'No url set.' error message.
Here's my grid...
var lastsel;
var selrow;
jQuery("#crud").jqGrid({
url:'_getGrid.php?nd='+new Date().getTime(),
datatype: "json",
colNames:['ID','First Name','Last Name','Address','City','State','Zip Code', 'Phone', 'Birth Date', 'Notes'],
colModel:[
{name:'customer_id', index:'customer_id', width:50, editable:true, editoptions:{readonly:true}},
{
name:'firstName',
index:'firstName',
width:100,
editable:true,
editoptions:{
size:20
},
formoptions:{
rowpos:1,
label:'First Name',
elmprefix:"(*)"
},
editrules:{
required:true
}
},
{name:'lastName',index:'lastName', width:120, editable:true, editoptions:{size:20}, editrules:{required:true}},
{name:'address',index:'address', width:200, editable:true, editoptions:{size: 30}},
{name:'city', index:'city', width:100, editable:true, editoptions:{size:20}},
{name:'state',index:'state', width:50,
editable:true,
edittype:'select',
editoptions:{value:"AL:AL;AK:AK;AZ:AZ;AR:AR;CA:CA;CO:CO;CT:CT;DE:DE;FL:FL;GA:GA;HI:HI;ID:ID;IL:IL;IN:IN;IA:IA;KS:KS;KY:KY;LA:LA;ME:ME;MD:MD;MA:MA;MI:MI;MN:MN;MS:MS;MO:MO;MT:MT;NE:NE;NV:NV;NH:NH;NJ:NJ;NM:NM;NY:NY;NC:NC;ND:ND;OH:OH;OK:OK;OR:OR;PA:PA;RI:RI;SC:SC;SD:SD;TN:TN;TX:TX;UT:UT;VT:VT;VA:VA;WA:WA;WV:WV;WI:WI;WY:WY"}
},
{name:'zipcode', index:'zipcode', width:60, align:"right", hidden:true,editable:true,editoptions:{size:10},editrules:{edithidden:true,number:true}},
{name:'phone', index:'phone', width:90, align:"right", hidden:true,editable:true,editoptions:{size:11},editrules:{edithidden:true,required:true}},
{name:'birthdate', index:'birthdate', width:60, align:"right", hidden:true,editable:true,editoptions:{size:10},editrules:{edithidden:true}},
{name:'notes', index:'notes', width:100, sortable:false,editable: true,edittype:"textarea", editoptions:{rows:"5",cols:"30"}, search:false}
],
pager: jQuery('#pager2'),
rowNum:10,
rowList:[10,20,30],
imgpath:'css/themes/green/images/',
sortname: 'customer_id',
viewrecords: true,
sortorder: "asc",
caption: "CRUD Contact Management Application",
//editurl:'_editGrid.php',
height:210,
scrollrows : true
}).navGrid("#pager2",
{edit:true, add:true, del:true, search:true},
{height: 400, width: 420, savekey: [true,13], navkeys: [true,38,40], reloadAfterSubmit:false,jqModal:false, closeOnEscape:true, url:'_editGrid.php', bottominfo:"Fields marked with (*) are required"}, // edit options
/*
{view:true}, //options
*/
{height: 360, width: 400, savekey: [true,13], navkeys: [true,38,40], reloadAfterSubmit:false,jqModal:false, closeOnEscape:true, url:'_delete.php', bottominfo:"Fields marked with (*) are required"}, // add options
/*
{height: 100, reloadAfterSubmit:false,jqModal:false,closeOnEscape:true, url:'_delete.php'}, // del options
*/
{closeOnEscape:true}, // search options
{navkeys: [true,38,40], height:400,jqModal:false,closeOnEscape:true}
) // view options
});
// Delete Selected Row
$("#crud").click(function(){
var gr = jQuery("#crud").getGridParam('selrow'); //getSelectedRow();
if( gr != null ){
jQuery("#crud").deleteGridRow(gr,{reloadAfterSubmit:false, url:'_delete.php'});
}
else {
alert("Please Select Row to delete!");
}
});
// Edit Selected Row
$("#crud").click(function(){
var gr = jQuery("#crud").getGridParam('selrow');
if( gr != null ){
jQuery("#crud").editGridRow(gr,{height:280,reloadAfterSubmit:false, url: '_editGrid.php'});
}
else {
alert("Please Select Row");
}
});
Thanks.
JohnM
It's not who I am underneath, but what I do that defines me.
12:23

Moderators
30/10/2007

Hello,
I Think the problem is here:
{view:true}, //options
In the navigator options between edit and add.
Regards
Tony
For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.
Most Users Ever Online: 715
Currently Online:
154 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.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66