Re: [SQLObject] INSERT INTO and cursor

[Oleg B. <ph...@ph...>]

Hi!

On Tue, Jan 22, 2013 at 03:21:06PM -0500, Markos Kapes <mk...@gm...> wrote:
> Any good reason why this code should fail to insert while the underlying query in mysql shell works?
> 	cursor=cbx.conn.cursor()
> 	cursor.execute(u"INSERT INTO notes (message, author) VALUES ('test', 'test');")
> Furthermore, this fails silently, so no error to give me a clue.
> Selects still work as expected, but somehow, all the old legacy code I've got that uses statements of the above type have stopped working.
> As always, thanks much for the advice,

   If there is no error, in what way it fails? It didn't insert the row?
Could it be an automatic rollback at the end of a transaction?

Oleg.
-- 
     Oleg Broytman            http://phdru.name/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.