Would you show your model? Richard
On Wed, Jul 13, 2011 at 2:08 PM, Ismael Alejandro <[email protected]>wrote: > 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 >>>> >>>> >>>> >>> >> >
