jQuery Grid Plugin - jqGrid - Topic: Get Select field options in dependence of a second select field http://www.trirand.com/blog/?page_id=393/help/get-select-field-options-in-dependence-of-a-second-select-field Simple:Press Version 5.7.5.3 kramoo6 on Get Select field options in dependence of a second select field http://www.trirand.com/blog/?page_id=393/help/get-select-field-options-in-dependence-of-a-second-select-field#p25134 Help http://www.trirand.com/blog/?page_id=393/help/get-select-field-options-in-dependence-of-a-second-select-field#p25134 Ohh sorry!!

In the variable sv it gets from the cell was a space at the end of the string.

Know it works !

]]> Fri, 11 Nov 2011 18:10:36 +0200 kramoo6 on Get Select field options in dependence of a second select field http://www.trirand.com/blog/?page_id=393/help/get-select-field-options-in-dependence-of-a-second-select-field#p25133 Help http://www.trirand.com/blog/?page_id=393/help/get-select-field-options-in-dependence-of-a-second-select-field#p25133 Ok it works.

I only have one probleme.

If i edit a row in the form it shows me the right value of the first select field but the wrong value of the second depended select field.

In the second select field it use the first <option> entry.

If i use the buttons next i get the next row and the right value for the second select field.

colModel :[

{name:'projektname', index:'projektname', width:160, sorttype:"string", edittype:"select",  editoptions:{"value":selectfeldProjektname['responseText'],"separator":":"}, editable:true },

{name:'unterprojektname', index:'unterprojektname', width:160, sorttype:"string",edittype:"select",editoptions:{"value":" :select"},editable:true},

….

"beforeShowForm":function(formid)
    {
  // get the value of the country
    var cntryval = $("#projektname",formid).val();
    jQuery("#unterprojektname",formid).html("<option>Select</option>");
    if(cntryval) {
      // if the value is found try to use ajax call to obtain the citys
        // please look at file file city.php
        jQuery.ajax({
            url: '/backlink/get-unterprojektname',
            dataType: 'html',
            //async: false,
            data: {q:cntryval},
            success : function(response)
            {
                sv="";
                var sr = jQuery("#list").jqGrid('getGridParam','selrow');
                console.log (sr);
                if(sr)
                {
                  // get the selected city from grid
                    sv = jQuery("#list").jqGrid('getCell',sr,'unterprojektname');
                    
                
                    // empty the select and put the new selection
                    jQuery("#unterprojektname",formid).html("").append(response);
                    if(sv)
                    {
                        console.log (sv);
                    // select the city value
                        jQuery("#unterprojektname",formid).val(sv).removeAttr("disabled");
                    }
                }
            }
        });
    } else {
        jQuery("#unterprojektname",formid).attr("disabled","disabled");
    }
    },

console.log (sr) = 4

console.log (sv) = oekostrom

request from url: '/backlink/get-unterprojektname' = <option value='stromrechner-vergleich'>stromrechner-vergleich</option>
<option value='oekostrom'>oekostrom</option>….

Html from second select field:

<select role="select" id="unterprojektname" name="unterprojektname" size="1″ class="FormElement">
<option value="stromrechner-vergleich">stromrechner-vergleich</option>
<option value="oekostrom">oekostrom</option>
….
</select>

What can be wrong??

]]> Fri, 11 Nov 2011 17:54:38 +0200 kramoo6 on Get Select field options in dependence of a second select field http://www.trirand.com/blog/?page_id=393/help/get-select-field-options-in-dependence-of-a-second-select-field#p25110 Help http://www.trirand.com/blog/?page_id=393/help/get-select-field-options-in-dependence-of-a-second-select-field#p25110 Hallo,

i use dataUrl to get the html for the select field from the DB.

colModel :[
       {name:'projektname', index:'projektname', width:160,
                            editable: true,
                            edittype:"select",
                            editoptions:{dataUrl:'/backlink/get-projektname'} //, defaultValue:'Intime'}
                            //formoptions:{ rowpos:3,elmprefix:"&nbsp;&nbsp;&nbsp;&nbsp;" }
            },

now i have a second select field. This should get the html for the field from DB in dependence from the first one.

{name:'unterprojektname', index:'unterprojektname', width:160,
                            editable: true,
                            edittype:"select",
                            editoptions:{dataUrl:'/backlink/get-unterprojektname?selectfieldone=value'} //, defaultValue:'Intime'}
            },

How can I get the value of the first select field to the dataUrl of the second select field? Or is there another way?

Thanks.

]]> Thu, 10 Nov 2011 12:17:05 +0200