[Zope] NULL in datefields in DB and Zope

e.frerich@nord-com.net e.frerich@nord-com.net
Mon, 17 Dec 2001 16:11:38 +0100


<color><param>0100,0100,0100</param>Hello,


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

"<bold><FontFamily><param>Times New Roman</param><bigger>Error Type: ValueError</bold>
<bold>Error Value: Invalid value, 0000-00-00, for Faelligkeit in record 2</bold>


<FontFamily><param>Arial</param><smaller>The exception is raised in:<FontFamily><param>Times New Roman</param><bigger>

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


<FontFamily><param>Arial</param><smaller>How can I get the records with NULL-values in datefields with a ZSQL-Method?


Regards,


Egon<FontFamily><param>Times New Roman</param><bigger>

<FontFamily><param>Arial</param><smaller> 

<nofill>