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
