[Koha-patches] [PATCH] bug 4312 change default for tagsmoderation to 0 from NULL

Galen Charlton gmcharlt at gmail.com
Thu Jun 24 04:35:55 CEST 2010


Hi,

On Tue, Jun 22, 2010 at 5:49 PM, Nicole Engard
<nengard at bywatersolutions.com> wrote:
> +    $dbh->do("UPDATE systempreferences SET value = '0' WHERE variable = 'TagsModeration' AND value = 'NULL'");

SQL handles null variables in a special way - the test you have to use
to check for nullity is 'is null', not "= 'NULL'".

Regards,

Galen
-- 
Galen Charlton
gmcharlt at gmail.com


More information about the Koha-patches mailing list