Whoops, this was a typo. The code is actually: insert into TableName (Date) values ("10/24/2001") I'm still looking for a solution to the problem. Micah From: "Capesius, Alan" <CapesiusA@S...> Date: Wed Oct 24, 2001 10:13 pm Subject: RE: [Zope] can't store a date in Access database "Insert into" or just "Insert" rather than "Insert in"
-----Original Message----- From: Micah Martin [mailto:micah@o...] Sent: Wednesday, October 24, 2001 4:47 PM To: 'zope@z...' 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@o... www.objectmentor.com, www.xprogramming.com www.pairprogramming.com, www.junit.org