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

[Micah Martin]

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