Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Data Model Questions /

Getting DataObjects with NULL values


Reply


3 Posts   775 Views

Avatar
NicolasLeuenberger

Community Member, 10 Posts

20 January 2012 at 11:00pm

Hi dear community

One of my models is an event (AgendaEintrag) with a DateField. If no date is set, the MySQL-Entry contains the value NULL. Now I'd like to display all Events without a date. This does not work:

$agendaEintraege = DataObject::get("AgendaEintrag", "Date=NULL", "Date ASC");

If I search for anything else, it works. I can for example display past events:

$agendaEintraege = DataObject::get("AgendaEintrag", "Date=<CURDATE()", "Date ASC");

Any idea how I can get those NULL containing entries? Thanks :-)

Avatar
swaiba

Forum Moderator, 1799 Posts

20 January 2012 at 11:06pm

how about "Date IS NULL" I think that is how MYSQL does it

Avatar
NicolasLeuenberger

Community Member, 10 Posts

20 January 2012 at 11:08pm

Jackpot!

Wow, that was fast and the perfect answer. Thanks so much :-)