Not working :( On Wed, Jul 13, 2011 at 1:02 PM, Richard Vézina <[email protected] > wrote:
> Maybe you forgot : db.commit() > > Richard > > > On Wed, Jul 13, 2011 at 1:59 PM, Ismael Alejandro > <[email protected]>wrote: > >> well, nothing is inserted >> >> >> 2011/7/13 Kenneth Lundström <[email protected]> >> >>> > 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 >>> >>> >>> >> >
