[Zope] invalid date problem

Skip Montanaro skip@pobox.com
Tue, 29 Oct 2002 16:48:33 -0600


    Jeff> Error Type: ValueError
    Jeff> Error Value: Invalid value, 0000-00-00, for DATE_START in record 6

    Jeff> How can I work around this?

If you can modify the database schema, try adding a "default" attribute to
the DATE_START field so it has a legitimate default value which is still out
of the range for your possible data values.  For example:

    create table foo (
        ...
        DATE_START date default '1953-11-25',
        ...
    );

(ALTER TABLE syntax is similar, thought the precise incantation escapes my
neuron's grasp at the moment.)

-- 
Skip Montanaro - skip@pobox.com
http://www.mojam.com/
http://www.musi-cal.com/