[Zope] Forms + MySQL + DateTime = a mess

[Richard Wesley]

At 7:52 PM -0700 8/5/02, Dennis Allison wrote:
>I think I have finally traced down at least some of my problem.
>The MySQL DA adaptor is smart -- for DateTime columns it wants a
>DateTime object and it returns a DateTime object.  Mixing strings
>and DateTime objects is not a good idea so I have modified my
>stuff to keep everything as a string until it goes into the
>database (or there's a need for a DateTime quantity) and, when
>it comes out from the database and is needed as a string, I
>force an explicit conversion.  Simple, but hard to track down when
>the infomation flow is complex.

I was going to respond by telling you to do just this ;-)

In general, I find that I need to treat everything entered by the 
user as a string and convert it to the db type as part of the 
validation process.
Sincerely,

Richard Wesley
Co-President, Electric Fish, Inc.
<http://www.electricfish.com/>
(v) +1-206-493-1690x210
(f) +1-206-493-1697