[Zope] NULL in datefields in DB and Zope

e.frerich@nord-com.net e.frerich@nord-com.net
Tue, 18 Dec 2001 15:17:13 +0100


Hi Florent, 


I changed everything into normal text: 


If there are no values in a column with dates in my database 
(mySQL) the  database returns "0000-00-00". ZOPE says: 

"Error Type: ValueError
 Error Value: Invalid value, 0000-00-00, for Faelligkeit in record 2"


The exception is raised in: 

...\lib\python\Shared\DC\ZRDB\RDB.py, line 272 


How can I get the records with NULL-values in datefields with a 
ZSQL-Method? 


Regards, 


Egon 

 


<nofill>