Hi, I’m trying to load a multicolumn combo in a form. But when I open the combo, it shows just one column. I can´t find any problem or what is happening
This is the code
formDietaFam=[
{type:"combo",name:"paciente", label:"Paciente",labelWidth:100,inputWidth:500,template:{
input:"#habitacion#,#nombre#",
columns:[
{header:"Folio",width:50,option:"#folio#"},
{header:"Habitacion",width:100,option:"#habitacion#"},
{header:"Nombre",width:200,option:"#nombre#"},
]
}},
{type: "button", name:"submit", value:"Aceptar"},
];
//AFTER I WROTE THIS TO SHOW THE FORM
toolbar_2.attachEvent("onButtonClick",function(btn){
if(btn=="tmp"){
var popupWindow=principal.dhxWins.createWindow("newcontact_win",0,0,800,400);
popupWindow.center();
popupWindow.setText("DATA");
var formDatos=popupWindow.attachForm(formDietaFam);
var combopac=formDatos.getCombo("paciente");
combopac.loadXML("comboLoading.php");
}
});
//THIS IS THE CONTENT OF comboLoading.php
<?php
require_once("./codebase/combo_connector.php");
$res=mysql_connect($host,$user,$pwd);
mysql_select_db($database);
$comboconn = new ComboConnector($res,"MySQL");
$comboconn->render_sql("SELECT id,'NAME' AS nombre, 'hab' AS habitacion FROM hospitalizacion WHERE estatus IN ('Ingreso','Prealta','Revision') AND habitacion NOT LIKE 'CUN%' AND habitacion NOT LIKE 'CONS%' AND habitacion NOT LIKE '' AND habitacion NOT LIKE 'AMBU%'","id","id,nombre,habitacion");
?>
This is what happens when I try to open the box
I know the query is ok because in mysql show the correct result (the data are test data)
Even when y run the combo in chrome shows one value
So I don’t know what is wrong here.