List of values

[verosb]

How can I implement a list of selection of values taken of a database PHP in my Sigma Grid?

[JLG]

Here's a bit of code I've used successfully. It utilized the beforeLoad() function that can be defined in grid options. It does an ajax call to page returning a comma-separated list of values to populate within a drop down column.



beforeLoad : function () { var myConn = new XHConn(); if (! myConn) alert("XMLHTTP not available. The browser you are using will not allow me to refresh the list of team leaders."); var fnWhenDone = function (oXML) { var responseText = oXML.responseText; var reportsToCol = project_team_members_grid.getColumn("reportsTo"); var leaders = responseText.split(","); reportsToCol.editor.valueDom.options.length = leaders.length; for (var i=0; i < leaders.length; i++) { reportsToCol.editor.valueDom.options[i].text = leaders[i]; reportsToCol.editor.valueDom.options[i].value = leaders[i]; } }; myConn.connect("ajax/project_drop_down_list_value_request.php", "POST", "requested_list=current_team_leaders", fnWhenDone); },