[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/