My code:
//PAIS (Visible)
{ name:'pais',
index:'pais',
width:90,
align: "center",

// --- Edición ---
editable:true,
formoptions:{elmprefix:"(*)" },
editrules:{required:true},
edittype: 'select',
editoptions: {
dataEvents: [{
type: 'change',
fn: function(e) {
var codpais = e.currentTarget.value;
var prov = $.ajax ({
url: 'dbprovincia.php?p='+codpais,
async: false}).responseText;
$("#grid").setColProp('provincia', {editoptions: {dataUrl: prov }});
}
}],
dataUrl: 'dbpais.php',
defaultValue: 'España',
},
},
//PROVINCIA (Oculto)
{ name:'provincia',
index:'provincia',
width:90,
align: "center",

// --- Edición ---
editable:true,
hidden: true,
formoptions:{elmprefix:"(*)" },
editrules: {edithidden: true, required:true},
edittype:'select',
editoptions: {
dataUrl: 'dbpronvicias.php',
},
},

Thanks!

Simone, please be a more precise. What you use actually? In the previous post you tell me that only surl work.

The surl option is used in search modules - especially in filterGrid and filterToolbar methods.

In order to be clear, please post your code and tell me what you try to do.

Reagrds

Tony

tony said:

Hello,

Which search module (method) do you use?

Please refer to docs and the important notes here:

http://www.trirand.com/jqgridw.....rch_config

I read the docs thoroughly, I'm using inline editing.

here is the code:

    {name:'id384',index:'id384',
            sortable:true,
            editable:true,
            edittype:"select",

            editoptions:{dataUrl:'Opc/HlpTabla.php?zTabla=st384',
                        dataEvents: [
                          {  type: 'change',
                             fn: function(e) {
                                alert($("#id384").val());
                                $("#id195").parent().load('Opc/HlpTabla.php?zTabla=st195&key=id384&val='+$("#id384").val());
                             }
                          }],}
        },
        {name:'id195',index:'id195',
            sortable:true,
            editable:true,
            edittype:"select",
            editoptions:{value:{}}
        },

The HlpTabla.php return something live "<select><option></option>...</select>"

Fisrt time it loads ok and works but if I change the id384 contents it doesn´t update the id195 select

Thanks for help me.

Martin

Which search module (method) do you use?

Please refer to docs and the important notes here:

http://www.trirand.com/jqgridw.....rch_config

My example here:

CGI scenario (perl)

my $cgi = new CGI;
print $cgi->header("Content-type: text/xml;charset=windows-1251");

print "<?xml version='1.0' encoding='windows-1251'?>";
print '<select>';
print "<option value='2'>alfa romeo</option>";
print "<option value='4'>ferrari</option>";
print "<option value='30017'>fiat</option>";
print '</select>';

JavaScript:

{name:'car_name', index:'car', width:120, align:'center', editable:true, edittype:"select", editoptions:{dataUrl:'cgi-bin/ccs_get_car.pl'}},

Looking at the documentation here I see dataUrl mentioned:

This option is valid only for the elements of type select - i.e stype:'select'. The option represent the url from where we load the select element. When this option is set the element will be filled with values from the ajax request. The data should be a valid html select element with the desired options. By example the request should contain <select><option value=“1”>One</option> <option value=“2”>Two</option></select>. This is called only once.

But dataUrl, as reported by others, isn't working, while surl is. So I was just asking if the docs are out of date, or where I should look to see it documented.

This is not a serious post. No answer.

Regards

Tony

Now is working! Sorry and thanks!

martin

Tha dataUrl parameter should work. You will need just to check when you edit row if the url is correct and this url return the values.

Regards

Tony

Thanks and sorry for the question. I´m new with Jqgrid

the command dataUrl doesn´t work for this?

Thanks!

    // get your slectfor edit
    var dll= $.ajax({
        url: 'Opc/demo.php'
            , async: false
    }).responseText;

then {name:'cdu223',index:'cdu223', editable:true,edittype:'select', editoptions:{ value: dll}},

Ok. So, I´m using json

I create the select column and I create the demo.php file that echo json data.

Now. ¿How I assign the data in the select?

Thanks.

if it is xml then i think you can use echo

anyway u didn;t understand what

the wiki learned you 😛

it says there that it constructs <select>blablabla</select>

but in your js file you call for demo.php

that should return an array of type

”FE:FedEx;IN:InTime;TN:TNT;AR:ARAMEX”

In your case it will be: 1:valor 1, 2:valor2... etc

read carefully the wiki... it is well written

so you need to do as i wrote upper

make the select

execute it

fetch the result into an array

and echo it to js

good luck

¿you say that the demo.php file needs to return an json encoder format result? not select?

If you check de "dataUrl" at editoptions on Wiki it says that <select> have to be the return text.

If I use the content like you are saying How I make the call from "colModel" ?

Thanks a lot!

the format for select is:

{name:'ship',index:'ship', width:90, editable: true,edittype:”select”,

editoptions:{value:”FE:FedEx;IN:InTime;TN:TNT;AR:ARAMEX”}},

this will construct:

<select> 
<option value='FE'> FedEx </option> 
<option value='IN'> InTime </option> 
<option value='TN'> TNT </option> 
<option value='AR'> ARAMEX </option> 
</select>

if u want to populate your select with data from database

you need to:

$sql = “select data from database”;

$result = $mysql_query($sql);

$arr = mysql_fetch_array($result);

echo json_encode($arr);

something like this

Best regards,

Adrian

...

    {name:'cdu223',index:'cdu223', editable:true,edittype:'select', editoptions:{dataUrl:'Opc/demo.php'}},

....

where demo.php is very simple:

echo "<select>
    <option value='1'>Valor 1</option>
    <option value='2'>Valor 2</option>
    <option value='3'>Valor 3</option>
</select>";

Nothing happens. ¿someone can help me please?

Thanks