jQuery Grid Plugin - jqGrid - Topic: how to fill a select in editing form with a query http://www.trirand.com/blog/?page_id=393/help/how-to-fill-a-select-in-editing-form-with-a-query Simple:Press Version 5.7.5.3 whoknows on how to fill a select in editing form with a query http://www.trirand.com/blog/?page_id=393/help/how-to-fill-a-select-in-editing-form-with-a-query#p20302 Help http://www.trirand.com/blog/?page_id=393/help/how-to-fill-a-select-in-editing-form-with-a-query#p20302 Nice !

Thanks a lot :).

]]> Thu, 14 Oct 2010 10:05:06 +0300 bogoa666 on how to fill a select in editing form with a query http://www.trirand.com/blog/?page_id=393/help/how-to-fill-a-select-in-editing-form-with-a-query#p20299 Help http://www.trirand.com/blog/?page_id=393/help/how-to-fill-a-select-in-editing-form-with-a-query#p20299 it's work!!!

The solution is to use de dataUrl option in editoptions of colModel

jquery code:

colModel :[{name:'notification', index:'notification', width:110, align:'center', editable:true, edittype:'select', editoptions:{dataUrl:'/application/getNotificationSelect'}, searchoptions: { sopt: ['eq'], value:"true:Yes;false:No" }, stype: 'select'}]

server code:

public static void getNotificationSelect(){  
        String xml = "<select><option value='true'>Yes</option><option value='false'>No</option></select>";
        renderXml(xml);          
}

You only have to change the xml with other which was generated with your query items. This is only an example.

Note: renderXml(String xml) is a method of playframework which is the framework I use but you can use the same mothod to load the rows in the grid.

]]> Thu, 14 Oct 2010 00:30:37 +0300 whoknows on how to fill a select in editing form with a query http://www.trirand.com/blog/?page_id=393/help/how-to-fill-a-select-in-editing-form-with-a-query#p20290 Help http://www.trirand.com/blog/?page_id=393/help/how-to-fill-a-select-in-editing-form-with-a-query#p20290 Hi,

I have exactly the same problem, so if you find the answer let me know about it :).

]]> Wed, 13 Oct 2010 19:07:00 +0300 bogoa666 on how to fill a select in editing form with a query http://www.trirand.com/blog/?page_id=393/help/how-to-fill-a-select-in-editing-form-with-a-query#p20215 Help http://www.trirand.com/blog/?page_id=393/help/how-to-fill-a-select-in-editing-form-with-a-query#p20215 Hi, i have two tables and one of them depends of the other. So, when I want to add or edit a row of the second table, I need to fill a select with a query where the result are the diffents rows of the first table. Is it possible?

Thanks

]]> Sun, 10 Oct 2010 16:32:26 +0300