Forum

November 2nd, 2014
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_Related Related Topics sp_TopicIcon
defaultValue from database for edittype:"text"
09/08/2011
05:35
Avatar
emascarinas
United States
Member
Members
Forum Posts: 5
Member Since:
09/08/2011
sp_UserOfflineSmall Offline

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

09/08/2011
11:48
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline

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.

09/08/2011
21:45
Avatar
emascarinas
United States
Member
Members
Forum Posts: 5
Member Since:
09/08/2011
sp_UserOfflineSmall Offline

Thanks, Tony. Right on the dot!

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
23 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