New answers tagged sql
0
The way it should be done
For now (until they introduce full entities support somewhere in Joomla! 4.x) it is better to use JTable to store "entities". In that way you can simply set $updateNulls parameter in JTable::store() method o true. It also simplifies a lot of CRUD and validate operations making your programming faster. You can read more in a JTable ...
1
Found a way by adding an another parameter as below:
$db->updateObject('#__table2', $recObj, 'id', true);
The 4th parameter determines whether null values can be used or not. Default this will be set as false.
https://docs.joomla.org/API17:JDatabase::updateObject
Top 50 recent answers are included
