thank you! that was it. I created the table using a create table (select from....
which must have defaulted to InnoDb, now I just create it in a script. > -----Original Message----- > From: Carsten Haese [mailto:[EMAIL PROTECTED] > Sent: Friday, June 01, 2007 8:56 AM > To: Sells, Fred > Cc: python-list@python.org > Subject: Re: MySQLdb insert fails on one table > > > On Fri, 2007-06-01 at 11:48 -0400, Sells, Fred wrote: > > INSERT INTO valid_individuals (fname,lname,alias,email) > VALUES (%s,%s,%s,%s) > > [['xxxx', 'yyyy', 'zzzzz', 'aaaaaa']] > > > > this function works fine for several other tables, but on > this one I get no > > errors and there is nothing in the table. If I run the > equivalent insert on > > the command line, it's just fine. > > This usually indicates that the table is transaction-aware > (e.g. storage > mechanism InnoDB versus MyISAM) and you're not committing your > transaction, so the transaction gets rolled back when your > connection is > closed. > > HTH, > > -- > Carsten Haese > http://informixdb.sourceforge.net > -- http://mail.python.org/mailman/listinfo/python-list
