jQuery Grid Plugin - jqGrid - Topic: Cascade drop-down lists in the jqgrid http://www.trirand.com/blog/?page_id=393/help/cascade-drop-down-lists-in-the-jqgrid Simple:Press Version 5.7.5.3 twenjie88 on Cascade drop-down lists in the jqgrid http://www.trirand.com/blog/?page_id=393/help/cascade-drop-down-lists-in-the-jqgrid#p26160 Help http://www.trirand.com/blog/?page_id=393/help/cascade-drop-down-lists-in-the-jqgrid#p26160 Can anyone help me with the issue that my dropdown list display nothing?

in html:

{name:'obsolete',index:'obsolete',align:'center',edittype:"select",editoptions: {dataUrl:'server.php?q=234'},editable: true}

in server.php:

case 234:

echo "<select>

            <option value='4'>3</option><option value='1'>2</option>

</select>";

break;

Why the listbox return nothing? Please help. Thanks

]]> Fri, 16 Mar 2012 04:03:17 +0200 oruc on Cascade drop-down lists in the jqgrid http://www.trirand.com/blog/?page_id=393/help/cascade-drop-down-lists-in-the-jqgrid#p25972 Help http://www.trirand.com/blog/?page_id=393/help/cascade-drop-down-lists-in-the-jqgrid#p25972 Resolved the problem

use this

editoptions:{dataUrl:'drplace3_ld_place2_value.php?place1_id=0'}

 php

if($place1_id='0')

{

.....

}

Thanks

]]> Thu, 16 Feb 2012 17:38:27 +0200 oruc on Cascade drop-down lists in the jqgrid http://www.trirand.com/blog/?page_id=393/help/cascade-drop-down-lists-in-the-jqgrid#p25969 Help http://www.trirand.com/blog/?page_id=393/help/cascade-drop-down-lists-in-the-jqgrid#p25969 i do like that i find in example from

/blog/?page_id=393/help/dynamically-populate-select-dropdown/&value=dataEvents&type=1&include=1&search=1&ret=all

piece of code from link which i use

[spoiler]

 colModel:[

...

{name:'select_one',

editable: true,

edittype:"select",

editoptions: {

dataUrl:'test_one.php',

dataEvents :[

{ type: 'change', fn: function(e) {

var thisval = $(e.target).val();

$.get('test_two.php?myid='+thisval, function(data)

{ var res = $(data).html();

$("#select_two").html(res);

}); // end get

}//end func

} // end type

] // dataevents

} // edit option

},
{name:'select_two',editable: true,edittype:"select", editoptions:{dataUrl:'test_two.php?myid=initialid'}}       

…
],

[/spoiler]

Piece my code for initialization table

[spoiler]

colModel :[

                 {name:'place3_id', index:'place3_id', width:30,align:'left',sortable:true},

                 {name:'place1_id', index:'place1_id', width:64, align:'left', editable:true, edittype:'text',sortable:true,edittype:'select',

                 editoptions:{dataUrl:'drplace3_ld_place1_short_value.php',dataEvents :[{type: 'change',

                                                                                                                                                                                                                                                                fn: function(e)

                                                                                                                                                                                                                                                                {

                                                                                                                                                                                                                                                                var thisval = $(e.target).val();

                                                                                                                                                                                                                                                                $.get('drplace3_ld_place2_value.php?place1_id='+thisval,

                                                                                                                                                                                                                                                                function(data)

                                                                                                                                                                                                                                                                {var res = $(data).html();

                                                                                                                                                                                                                                                                $("#place2_id").html(res);

                                                                                                                                                                                                                                                                }); // end get

                                                                                                                                                                                                                                                                }//end func

                                                                                                                                                                                                                                                                } // end type

                                                                                                                                                                                                                                                                ],// dataevents

                                                                                                                                                                                                                                                                }},

     {name:'place2_id', index:'place2_id', width:32, align:'left', editable:true, edittype:'text',sortable:true,

                 editoptions:{dataUrl:'drplace3_ld_place2_value.php?place1_id=initialid'},edittype:'select'},

     {name:'place3_value', index:'place3_value',width:32,align:'left',editable:true,edittype:'text',sortable:true}

                 ],//colModel

[/spoiler]

drplace3_ld_place1_short_value.php

[spoiler]

<?php

$tsql = "SELECT place1_id,place1_short_value From drplace1";

$stmt = sqlsrv_query($conn1, $tsql);

print "<select>";

while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC))

{

   print "<option value=".$row['place1_id'].">".$row['place1_short_value']."</option>";

}

print "</select>";

sqlsrv_free_stmt( $stmt );

sqlsrv_close( $conn1 );

?>

[/spoiler]

drplace3_ld_place2_value.php

[spoiler]

<?php

$place1_id = $_GET['place1_id'];

$tsql = "SELECT place2_id,place2_value From drplace2 where place1_id=?";

$params = array(&$place1_id);

$stmt = sqlsrv_prepare($conn1,$tsql,$params);

sqlsrv_execute( $stmt);

print "<select>";

while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC))

{

   print "<option value=".$row['place2_id'].">".$row['place2_value']."</option>";

}

print "</select>";

sqlsrv_free_stmt( $stmt );

sqlsrv_close( $conn1 );

?>

[/spoiler]

My second drob-down list is empty help please

]]> Thu, 16 Feb 2012 15:13:45 +0200 oruc on Cascade drop-down lists in the jqgrid http://www.trirand.com/blog/?page_id=393/help/cascade-drop-down-lists-in-the-jqgrid#p25967 Help http://www.trirand.com/blog/?page_id=393/help/cascade-drop-down-lists-in-the-jqgrid#p25967 Thanks my brather i find same topics

]]> Thu, 16 Feb 2012 08:56:54 +0200 tony on Cascade drop-down lists in the jqgrid http://www.trirand.com/blog/?page_id=393/help/cascade-drop-down-lists-in-the-jqgrid#p25966 Help http://www.trirand.com/blog/?page_id=393/help/cascade-drop-down-lists-in-the-jqgrid#p25966 Hello,

You can find here a lot of posts regarding this:

By example you can search with "depend listbox" and etc

Regards

]]> Thu, 16 Feb 2012 08:39:26 +0200 oruc on Cascade drop-down lists in the jqgrid http://www.trirand.com/blog/?page_id=393/help/cascade-drop-down-lists-in-the-jqgrid#p25961 Help http://www.trirand.com/blog/?page_id=393/help/cascade-drop-down-lists-in-the-jqgrid#p25961
Hello!
Question about dynamic select in JqGrid. In the window when editing or addingentries have two select the choice of the value of the first select list to change the listof the second, data is retrieved from the database. With the first selector figured out,but the second is not clear: how to change the first select call a script for a second?
piece of code
Formation of the table:
colModel: [{name: 'idObjectProject', index: 'idObjectProject', width: 300, editable: true, edittype: "select", editoptions: {dataUrl: 'test.php'}},
{name: 'idWorkProject', index: 'idWorkProject', width: 300, editable: true, edittype: "select", editoptions: {dataUrl: 'test1.php'}}],

Thank you all in advance

]]> Thu, 16 Feb 2012 08:03:26 +0200