[Zope] setting null date in SQL-resolved

Kelley, Sean SKelley@ci.santa-rosa.ca.us
Mon, 2 Jun 2003 09:20:34 -0700

Thanks for your help-  I realized that if I put this in the form input
null="" then it all worked out.

-----Original Message-----
From: McDonnell, Larry [mailto:lmcdonnell@protonenergy.com]
Sent: Monday, June 02, 2003 7:06 AM
To: Kelley, Sean; 'zope@zope.org'
Subject: RE: [Zope] setting null date in SQL


I can do this to an MS Access DB:

<dtml-if mea_creation_date><dtml-if "mea_creation_date==''">NULL<dtml-else>
 <dtml-sqlvar mea_creation_date

-----Original Message-----
From: Kelley, Sean [mailto:SKelley@ci.santa-rosa.ca.us]
Sent: Friday, May 30, 2003 5:06 PM
To: 'zope@zope.org'
Subject: [Zope] setting null date in SQL

I cannot seem to set date to NULL in MS SQL with INSERT but it seems to work
on UPDATE with this code:
Insert sets date to 1/1/1900

<dtml-if "AppDelDate==''">
'<dtml-var name="AppDelDate" sql_quote>',

Trying this request to the group again since I have not found a solution.

Zope maillist  -  Zope@zope.org
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-dev )