$GLOBALS["db"]->query() not working in before save logic hook

Anand Chitikela over 9 years ago

I want to execute an sql statement in the before save logic hook.

I have tried

$GLOBALS['db']->query("UPDATE users SET description='test' WHERE id='27283e5a-8f34-b846-367a-561fbbb4cb54'");

$db = DBManagerFactory::getInstance();

$res = $db->query("UPDATE users SET description='test' WHERE id='27283e5a-8f34-b846-367a-561fbbb4cb54'");

But it is not working.Shijin Krishna@

Parents

0 Roman R. over 9 years ago
If you use before save logic hook in module Users, Sugar logic overwrites field [Description].
You need use this:
function customHook(&$focus, $event, $arguments){ $focus->description = 'test'; }
0 Gustav Lindström over 9 years ago in reply to Roman R.

Update the bean instead
$user= BeanFactory::getBean('users', '27283e5a-8f34-b846-367a-561fbbb4cb54');
$user->description = 'Test';

Reply

0 Gustav Lindström over 9 years ago in reply to Roman R.

Update the bean instead
$user= BeanFactory::getBean('users', '27283e5a-8f34-b846-367a-561fbbb4cb54');
$user->description = 'Test';

Children