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
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
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!
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
interactivetools.com
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
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