jQuery Grid Plugin - jqGrid

i think that demo.php would have to return the data in an established format.

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

you have to do json_encode if your grid data type is json

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

The way is working is to make a not asyng call to your server and save the value before making your grid something like:

    // 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}},

I'm using 3.5.3 and dataUrl is not working, while surl is. If the documentation out of date?

Sorry?

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.

I still can't get it to work with dataUrl in searchoptions, just surl in colmodel. Does anyone know why?