Hi

I am using Java Script lib with own server side code.. using people code

i I am looking for some help with drop down box i am new to jqgrid… I am using colmodel in the colmodel i set the edit type select and populating the drop down box with a select from db… it is working correctly.. the issue i am having is if i select a value and save …on page load the value is there but when i go to the column and click it disappears… i need to set the value back if nothing is changed here is my code

&colModel = &colModel | “{name: 'coments', index: 'coments',align: 'right', label: 'Comments', editable: true, edittype: 'select', editoptions:{dataUrl: '/psc/ps/EMPLOYEE/EMPL/s/WEBLIB_T_DE_GRD.ISCRIPT1.FieldFormula.IScript_GetMeritCommentsSelect'}, width: 220, sortable: true, sorttype: 'text', resizable: false, classes: 'columncolor'},”;

This is the HTML which is generated by this

 
Contract EMPLOYEE
Employee Death
Employee On Leave
Lump Sum Merit
Merit Over Max, Mgr Approved
Employee Too New in Job/Pos
Non-Graded Position
Salary Over Max, Mgr Approved
Completing CMR via TAD
Employee Termination

I have tried to set it to selected value

&selSql = “SELECT A.T_CMR_COMMENTS , A.T_CMR_ELIGIBILITY, A.DESCR FROM PS_T_CMRCOMMENT_VW@” | &common.GetHCMDBName() | ” A “;

&selSql = &selSql | “WHERE A.STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.effdt) “;
&selSql = &selSql | “FROM PS_T_CMRCOMMENT_VW@” | &common.GetHCMDBName() | ” B ” | “WHERE B.T_CMR_COMMENTS = A.T_CMR_COMMENTS)”;
&Sql = CreateSQL();
&Sql.Open(&selSql);

&buildoptions = ““;
&buildoptions = &buildoptions | GetHTMLText(HTML.T_MSS_COMMENTS, ” “, ” “, ” “);
&buildoptions = &buildoptions | GetHTMLText(HTML.T_MSS_COMMENTS, ” “, ” “);
While &Sql.Fetch(&commentCode, &eligCode, &description);
If &thisValueAlreadySelected = &commentCode Then

&buildoptions = &buildoptions | “

“;
Else
&buildoptions = &buildoptions | “” | &description | ““;
End-If;
End-While;
&buildoptions = &buildoptions | ““;

%Response.Write(&buildoptions);