[Zope-DB] (no subject)

[McDonnell, Larry]

Hi Rob,

You can set your date variable to date within Access and store (insert) is
as follows:

<dtml-if request_date><dtml-if "request_date==''">NULL<dtml-else>
 <dtml-sqlvar request_date type=string></dtml-if><dtml-else>NULL</dtml-if>,

Update

wfo_comment_date=<dtml-if wfo_comment_date><dtml-if
"wfo_comment_date==''">NULL<dtml-else>
 <dtml-sqlvar wfo_comment_date
type=string></dtml-if><dtml-else>NULL</dtml-if>

I do this all the time.

-----Original Message-----
From: Rob Crotty [mailto:r_crotty@yahoo.com]
Sent: Tuesday, June 10, 2003 9:54 AM
To: zope-db@zope.org
Subject: [Zope-DB] (no subject)


Larry,

Thanks for that info.  In  my Access table I am using a text field for the
date as I have not figured out how to input as a date format from a ZSQL
method.  The types I am aware of are string, nb, float and int.  Is there
another type for date format input?

Thanks alot.

Rob




_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db