Grid + complex Update

Discontinued products Uncategorized discussions
#1


Hi, my question is why not update



code PHP + grid















































-----------CODE CONNECTOR -------------



require_once(”…/data/conectarse.php");

$link = conectarse2();

    require("…/scripts/grid/grid_connector.php");

    $grid = new GridConnector($link);

    $grid->enable_log(“temp.log”,true);

    

function my_update($action){

$alt=$action->get_value(“c2”);

$baj=$action->get_value(“baja”);

$edi=$action->get_value(“editar”);

$imp=$action->get_value(“imprimir”);

mysql_query(“UPDATE sis_permisos SET alta=’{$alt}’, baja=’{$baja}’, editar=’{$edi}’, imprimir=’{$imp}’ WHERE id=’{$action->get_id()}”);

$action->success(); //if you have made custom update - mark operation as finished

}

    

     $grid->event->attach(“beforeUpdate”,“my_update”);



$grid->render_sql(“select empleados.nombre,id_modulo,sis_permisos.alta,sis_permisos.baja,sis_permisos.editar,sis_permisos.imprimir from sis_permisos

INNER JOIN empleados ON sis_permisos.id_usuario = empleados.clave”,“sis_permisos.id”,“nombre,id_modulo,alta,baja,editar,imprimir”);



-------------------------------

update only

alta,baja,editar,imprimir

----------------

thanks
#2

Please beware that usage of
dp.enableDataNames(true);
will prevent any auto operation ( insert, update, delete)

You are using
mygrid.setColumnIds(“usuario,modulo,alta,baja,editar,imprimir”);
and
$alt=$action->get_value(“c2”);
There is no column with id == c2, most probably it must be a
$alt=$action->get_value(“alta”);

If issue still occurs - please provide the content of log file for problematic operation.