[Zope] ODBC: Fieldname: Datatype is of Timestamp data type default value error

[Charlie Reiman]

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 )
>