sqlobject-discuss

[SQLObject] INSERT INTO and cursor

[Markos K. <mk...@gm...>]

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,
--Markos Kapes

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.