[cvs] commit: ansel/lib Ansel.php ansel/scripts/upgrades 2008_02_29_fix_category_defaults.sql

[Michael Rubinsky]

mrubinsk    2008-02-29 16:51:25 EST

  Modified files:
    lib                  Ansel.php 
  Added files:
    scripts/upgrades     2008_02_29_fix_category_defaults.sql 
  Log:
  fix queries and force a IS NULL check whenever we want to test for NULL or
  an empty string. The latter is due to Oracle's idea that an empty string is
  the same thing as NULL.  This, plus the fact the MDB2 is set to translate
  an empty string to NULL when INSERTing or UPDATEing, should keep us portable.
  *sigh*
  
  Revision  Changes    Path
  1.334     +42 -5     ansel/lib/Ansel.php
  1.1       +1 -0      ansel/scripts/upgrades/2008_02_29_fix_category_defaults.sql (new)

  Chora Links:
  http://cvs.horde.org/diff.php/ansel/lib/Ansel.php?r1=1.333&r2=1.334&ty=u
  http://cvs.horde.org/co.php/ansel/scripts/upgrades/2008_02_29_fix_category_defaults.sql?r=1.1