AFTER EVENT

February 18, 2021, 04:46:52 PM

Hi again...what am i doing wrong?

$db->rawQuery('UPDATE dispositivo SET estadodisp = "ASIGNADO" WHERE id=$modeldata['dispositivo']');

this is in after event

Re: AFTER EVENT

Reply #1 – February 18, 2021, 07:21:33 PM

@nyacumo‍ it should be like this

Code: [Select]

$db->rawQuery('UPDATE dispositivo SET estadodisp = "ASIGNADO" WHERE id=$modeldata[dispositivo]');

or like this

Code: [Select]

$db->rawQuery('UPDATE dispositivo SET estadodisp = "ASIGNADO" WHERE id='.$modeldata['dispositivo']);

and not like this

Code: [Select]

$db->rawQuery('UPDATE dispositivo SET estadodisp = "ASIGNADO" WHERE id=$modeldata['dispositivo']');

The two single quotes in the model data variable are the culprit.

Re: AFTER EVENT

Reply #2 – February 19, 2021, 10:42:21 AM

Awesome!!!! thank you very Much!!!! you are a life saver and a kind person!