Maybe you forgot : db.commit() Richard
On Wed, Jul 13, 2011 at 1:59 PM, Ismael Alejandro <ialejandr...@gmail.com>wrote: > well, nothing is inserted > > > 2011/7/13 Kenneth Lundström <kenneth.t.lundst...@gmail.com> > >> > hi! I'm very confused, I'm trying to do a simple Insert, like this, >> db.person.insert(name = 'foo'), but It doesn't work (from a controller). >> >> What happens when you do it in a controller? Do you get an error? If not >> how do you know it does not work? >> >> >> Kenneth >> >> >> >> I tried trough appadmin in the query field (same query) and it shows me an >> error: >> >> (1064, u"You have an error in your SQL syntax; check the manual that >> corresponds to your MySQL server version for the right syntax to use near >> 'WHERE 6****' at line 1") >> >> ****This number is the corresponding ID of the inserted record. >> >> but, if I exit the page and then enter again the record is there and >> fine!! >> >> I need it to work from a controller but I can't. >> >> I'm using MySQL 5.1.41 and web2py 1.94.5 >> >> >> >