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