[egenix-users] Invalid Syntax for Insert stmt

[zhihua ouyang]

Try this:
 
c.execute("insert into Table1 (SSN, Field1) values
('44', 'mxPerson')")


Ouyang

--- Bob Buchanan <R.Buchanan at comcast.net> wrote:
> I keep getting 'Invalid syntax' when I try the
> following insert statement:
> c.execute('insert into Table1 (SSN, Field1) values
> ('44', 'mxPerson')')
>   
> Can you tell me why?  I'm using mxODBC to insert
> into an MSAccess db.
>   
>   
> Where can I find documentation for mxODBC?  The
> information contained on 
> www.egenix.com/files/python/mxODBC.html 
> <http://www.egenix.com/files/python/mxODBC.html> is
> not detailed enough.
> 
> Thanks in advance for your help.
> 


__________________________________________________
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com