Forum



05:35

09/08/2011

Hi there,
im a newbie to jqgrid and would like to check if there is a way to get the defaultValue of an edittype:text from a database. I see dataUrl is only for select type. I just need to get the last max number + 1 of a certain table field and set it as the default value.
name:'ItemNumber',index:'ItemNumber', width:120, align:"center",editable:true,editrules:{required:true,integer:true},editoptions:{
defaultValue:function(){
source: getmax_numberfromtable.php // something like this??? or is this posible?
}
}
},
thanks
11:48

Moderators
30/10/2007

Hello,
The defaultValue can be a function, but you will need maybe to use ajax:
name:'ItemNumber',index:'ItemNumber', width:120, align:"center",editable:true,editrules:{required:true,integer:true},editoptions:{
defaultValue:function(){
var ret = $.ajax({
url: 'getmax_numberfromtable.php',
async:false,
…
}).responseText
return ret;
}
}
}
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:
93 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