Where IS NOT NULL

3 posts by 2 authors in: Forums > CMS Builder
Last Post: May 21, 2009   (RSS)

By Djulia - May 20, 2009 - edited: May 20, 2009

Hi,

I use a field type list which is regularly updated in the table.

I use this field with the Where option :
'where' => 'adversary IS NOT NULL',

My problem, when the field is modified for a NULL value, the Null value is not indicated in the table (cf. Capture1.gif).

Does somebody have an idea ?
There is perhaps a solution with MySQL Column Type ?

Thanks very much for your answers !

Djulia
Attachments:

capture1_007.gif 4K

Re: [Djulia] Where IS NOT NULL

By Dave - May 20, 2009

Hi Djulia,

How are you getting NULL values?

Would it work just to change your where?

'where' => ' adversary IS NOT NULL AND adversary != "" ',

Hope that helps!
Dave Edis - Senior Developer
interactivetools.com