[Zope] can't store a date in Access database

Capesius, Alan CapesiusA@Sysmex.com
Wed, 24 Oct 2001 17:13:39 -0500


"Insert into"
or just
"Insert"

rather than
"Insert in"



>>>-----Original Message-----
>>>From: Micah Martin [mailto:micah@objectmentor.com]
>>>Sent: Wednesday, October 24, 2001 4:47 PM 
>>>To: 'zope@zope.org'
>>>Subject: [Zope] can't store a date in Access database
>>>
>>>
>>>Hello,
>>>
>>> This is the error the is troubling me:
>>>
>>>Error Type: sql.error
>>>Error Value: ('37000', -3502, '[Microsoft][ODBC Microsoft 
>>>Access Driver]
>>>Syntax error in INSERT INTO statement.')
>>>
>>>My SQL statement: 
>>>insert in TableName (Date) values ("10/24/2001")
>>>
>>>I have tried at least a dozen different date formats 
>>>including the wierd '#'
>>>delimiters.   Anyone solve this problem?
>>>
>>>	Micah
>>>
>>>-------------------------------------------------------------
>>>---------------
>>>--
>>>Micah Martin
>>>Software Engineer
>>>Object Mentor, Inc.
>>>micah@objectmentor.com
>>>www.objectmentor.com, www.xprogramming.com
>>>www.pairprogramming.com,  www.junit.org
>>>
>>>
>>>
>>>_______________________________________________
>>>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 )
>>>