db.define_table('person', Field('name','string')) On Wed, Jul 13, 2011 at 1:11 PM, Richard Vézina <ml.richard.vez...@gmail.com > wrote:
> Would you show your model? > > Richard > > > On Wed, Jul 13, 2011 at 2:08 PM, Ismael Alejandro > <ialejandr...@gmail.com>wrote: > >> Not working :( >> >> >> On Wed, Jul 13, 2011 at 1:02 PM, Richard Vézina < >> ml.richard.vez...@gmail.com> wrote: >> >>> 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 >>>>> >>>>> >>>>> >>>> >>> >> >