29 Oct
2002
29 Oct
'02
10:48 p.m.
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/