Hi, How can it be a float when the <dtml-var temp_date> returns 2002/09/30 15:49:23.74 GMT-4?? -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Max M Sent: Monday, September 30, 2002 1:48 PM To: McDonnell, Larry Cc: 'Zope@Zope.Org' (E-mail) Subject: Re: [Zope] Storing a ZopeTime() within an MS Access DB McDonnell, Larry wrote:

I am running into a wall when it comes to populating the variable arch_date with ZopeTime. I have a web form that I need to generate an audit trail. Before I write the updated record, I dtml-in the active table and write the "old" information in an archive table. I added a date field (arch_date) to the archive table but I do not know how to save the variable in my ZSQL Method.

I believe that DateTime is in fact a float and that you will probably need to convert it to a string of the correct format. Then your database will probably automatically convert it to an internal date format. regards Max M

<evolve>

...

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