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: [Dave] Where IS NOT NULL

By Djulia - May 21, 2009

Hi Dave, and thank you very much for your assistance.

Your solution is perfect !

[font "Verdana"]>> How are you getting NULL values?
In fact, value NULL was added by cmsB when the column was created in the table.

Thanks, Djulia