Combo for a column populate by connector

Suite and Optimus Suite 5
#1

Hi,

I trying to put a Combo in a specific column of a Grid and it’s populate by a MySQL server, like that: docs.dhtmlx.com/grid__columns_types.html#combo

But nothing append and I don"t find why…My grid get’s data front the connector but I didn’t see the combo when I try to edit my column.

Here’s my Grid and Combo code:

[code]Grid = itemLayout.cells(“a”).attachGrid();
Grid.setHeader("Name, Manufacturer,Type);
Grid.setColumnIds("g_name,g_manifacturer,g_type);
Grid.setColTypes(“ed,ro,combo”);
Grid.init();
Grid.itemsGrid.load(“data/data-items.php”)

comboType = itemsGrid.getColumnCombo(2); //(I get an error in my chrome console: Uncaught TypeError: undefined is not a function )
comboType.enableFilteringMode(true);
comboType.load(“data/tag-combo-taux.php”)
[/code]

And my connector code for the combo:

<?php
	require("../codebase/connector/combo_connector.php");
	$config = parse_ini_file('../../../config.ini'); 
	$res=mysql_connect("127.0.0.1",$config['username'],$config['password']);
		mysql_select_db($config['dbname']);

   $comboconn = new ComboConnector($res,"MySQL");
   $comboconn->render_table("tblTaux","taux_id","taux_name");
?>

Can you help me?
Thank.

#2

I find myself a simple solution, I load a XML grid config generate by a php code.

So my php code is if you has the same problem:

[code]<?php
header(“Content-type:text/xml”);

$config = parse_ini_file('../../../config.ini'); 
$ress=mysql_connect("127.0.0.1",$config['username'],$config['password']);
$db = mysql_select_db($config['dbname']);

$tbli = mysql_query("SELECT * FROM tblTaux");

print("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
print("<rows>");
print("<head>");
print('<column width="50" 	type="ed"  	align="left" sort="int">Name </column>'); //Column 1
print('<column  xmlcontent="1" width="*" type="coro" editable="true" >Type');  //Column 2 with combobox

$items = 0;
while($row = mysql_fetch_array($tbli)){

$type_name = $row['type_name'];
print("<option value=\"".$type_name."\">");
print($type_name);
print("</option>");
$items++; 
}
print("</column>");
print("</head>");
print("</rows>");

mysql_close($ress);

?>[/code]

And my js:

Grid.setColumnIds("name,type"); Grid.loadXML("data/itemsGridsConfig.php"); Grid.load("data/data-items.php");