Ok,
There seems that this should be explained.
First lets think what we should do to obtain the select values from db with the grid request (url option).
– We need to make additional query for this. The query should return a value name from table.
– These values can be merged in userdata option.
– Let suppose that after the additional query the result can be mergead into the string of type s = val1:name1;val2:name2….

then before to send the request back to jqGrid we can constuct a userdata this way (xml example)

echo s;

Then we can use loadComplete

loadComplete: function () {
var udata = $(“#mygrid”).getUserData();
$(“#mygrid”).setColProp(‘myselect_box’,editoptions:{value:udata.mylist});

}

Hope this help
Regards
Tony

Thank you for this information

Regards
Tony

Hi,
It seems that on hidden fields fck does not work.
You can do this without to change the formedit code. Simply use a one trick with afterShowForm event.
Let suppose you defined textarea field in colModel.
In edit options add this for these fielfds editoptions:{class:’fck’…}
Since afterShowForm is called every time you click on edit or create button you should call it only once. For this purpose define global variable something like

var aftershowcnt = false
then

afterShowForm : function(form_id) {
if (!aftershowcnt ) {
$(‘.fck’,form_id).fck( options )
aftershowcnt = true;
}

}

Regards
Tony

You should add fckeditor in filData function too.
something like:
….
case “text”:
case “textarea”:
case “fckeditor”:
$(“#”+nm,”#”+frmtb).val(tmp);
break;
….

I plan to implement some features such as required, number, minValue maxValue and etc.

Open jquery.jqGrid.js and see which .js files are you use. Maybe you use minified files. Change the paths to right files.

Regards
Tony

You mean freeze columns.

Not in current plan, but will add this in the list

Regards
Tony