optional stuff is usually used for select, not insert (as far as I know). I'd just hack it with an if: <dtml-if defaultDate> <dtml-sqlvar .... > <dtml-else> SYSDATE </dtml-if>
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of jj bbox Sent: Wednesday, October 16, 2002 10:25 AM To: zope@zope.org Subject: [Zope] ODBC: Fieldname: Datatype is of Timestamp data type default value error
Hello ZopeU,
Z SQL method insert into table values( ..., ..., <dtml-sqlvar defaultDate type=string optional> ..., )
If optional is used an error occurs due to null value. Any suggestions or solution for a defualt value for defaultDate if the user does not input a date???
Note defaultDate is of type Timestamp in an access db.
-jj
__________________________________________________ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )