select myFunction(ids) as objetivos from tbl_riesgos;
soo the column im trying to filter is objetivos so i have in my grid this:
$column = new GridColumn();
$column->DataField = "objetivos";
$column->HeaderText = "Objetivo";
$grid->MasterTable->AddColumn($column);
on koolgrid.php line 321
i got the variable $_select_command having the value:
SELECT * FROM (select * from qry_riesgos where id_proyecto = 33) AS _TMP WHERE objetivos LIKE '%Tiempo%' ORDER BY clave ASC LIMIT 0 , 9999999
wich is a good formed select command, i have tested it on phpmyadmin and it returns exactly the rows wich cointains Tiempo on the field objetivos.
but my grid displays no rows.
also the next line on koolgrid.php is:
$_result = mysql_query($_select_command, $this->_Link);
and $result is giving me a False; just like if the select comand returns no rows.
if the field is a common varchar(255) data filter works perfect.. why does it wont work with functionreturned fields ??