I have seen something similarly strange.
I have MySQL 4.1.0 installed on winxp.
I have installed a copy of MySQL-Front in order to get to know MySQL better, and when I used SQLObject 0.6.1 to create tables and insert rows, the tables showed up in MySQL-Front, but they looked empty. However, I wrote some more code to try reading the rows I thought I had written, and they showed up that way. Again, these are two separate scripts run separately, so python/SQLObject isn't just caching it.
Very odd.
John Page

On 16/07/05, Oleg Broytmann <phd@mail2.phd.pp.ru> wrote:
On Sat, Jul 16, 2005 at 09:26:53AM -0500, Christopher Singley wrote:
>  1/QueryIns:  INSERT INTO person (last_name, middle_initial, first_name)
> VALUES ('Doe', NULL, 'John')
> So on the surface, it appears to be working.
> However, none of these attempts have resulted in any rows being inserted
> into the database.

   Sounds like an autocommi issue. Cannot help - I seldom use MySQL. BTW,
what version of MySQL, Python and MySQLdb you use?
   Please try the latest version of SQLObject. Version 0.6.1 is really old.
Checkout the code from Subversion repository or use my unofficial tarball:

     Oleg Broytmann            http://phd.pp.ru/            phd@phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.

SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
sqlobject-discuss mailing list