Re: variable_exists() patch

At 12:36 15/08/2003, Thies C. Arntzen wrote:

On Fri, Aug 15, 2003 at 07:41:48AM +0800, Alan Knowles wrote: I hit this a couple of months ago.. trying to implement NULL support in dataobjects: $do = DB_DataObject::factory('test'); $do->get(12); $do->birthday = null; $do->update(); was supposed to generate SELECT * FROM test WHERE id=12; UPDATE test SET birthday=NULL where id = 12; or $do = DB_DataObject::factory('test'); $do->birthday = null; $do->find(); to do SELECT * FROM test WHERE birthday IS NULL; but since there was no effective way to detect null, as apposed to unset.. I had to give up... - If this could be solved by variable_exists() - even though var $birthday is defined.. It would be great..

    alan,

    you hit the "nail on the head" - zeev, do you see any way to
    solve alans problem?

Yep, there are several options, but using the language-level NULL is probably not one of them. You could have a setNull() method that defines the NULL values. You could have DB_DataObject::null_value defined to some value that is not used in SQL (e.g., an object) and use it instead. There are probably other ways as well... Zeev