[web2py] INSERT Error? or Bug?

2011-07-13 Thread Ismael Alejandro
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). I tried trough appadmin in the query field (same query) and it shows me an error: (1064, uYou have an error in your SQL syntax; check the manual that

Re: [web2py] INSERT Error? or Bug?

2011-07-13 Thread Kenneth Lundström
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

Re: [web2py] INSERT Error? or Bug?

2011-07-13 Thread Ismael Alejandro
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?

Re: [web2py] INSERT Error? or Bug?

2011-07-13 Thread Richard Vézina
Maybe you forgot : db.commit() Richard On Wed, Jul 13, 2011 at 1:59 PM, Ismael Alejandro ialejandr...@gmail.comwrote: 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,

Re: [web2py] INSERT Error? or Bug?

2011-07-13 Thread Ismael Alejandro
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.comwrote: well, nothing is inserted 2011/7/13 Kenneth Lundström

Re: [web2py] INSERT Error? or Bug?

2011-07-13 Thread Richard Vézina
Would you show your model? Richard On Wed, Jul 13, 2011 at 2:08 PM, Ismael Alejandro ialejandr...@gmail.comwrote: 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

Re: [web2py] INSERT Error? or Bug?

2011-07-13 Thread Ismael Alejandro
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.comwrote: Not working :( On Wed, Jul 13,

Re: [web2py] INSERT Error? or Bug?

2011-07-13 Thread Richard Vézina
And what about the db=DAL('mysql://username:password@localhost/test')... Can you see if web2py has create you person table into you mysql database? You can also try to make a little app that work with sqlite by default and try your exact same code in in so you will be able to determine if your

Re: [web2py] INSERT Error? or Bug?

2011-07-13 Thread Kenneth Lundström
What happens if you insert a record directly to mysql, can you view it from web2py. In controller return db(db.person.id 0).select() Kenneth db.define_table('person', Field('name','string')) On Wed, Jul 13, 2011 at 1:11 PM, Richard Vézina ml.richard.vez...@gmail.com

Re: [web2py] INSERT Error? or Bug?

2011-07-13 Thread Richard Vézina
MySQL 5.1.41 is kind of old... http://dev.mysql.com/doc/refman/5.1/en/news-5-1-41.html D.1.23. Changes in MySQL 5.1.41 (05 November 2009) Richard 2011/7/13 Kenneth Lundström kenneth.t.lundst...@gmail.com What happens if you insert a record directly to mysql, can you view it from web2py.

Re: [web2py] INSERT Error? or Bug?

2011-07-13 Thread Ismael Alejandro
I think is solved I was working in another function with almost the same name xD Sorry 2011/7/13 Kenneth Lundström kenneth.t.lundst...@gmail.com What happens if you insert a record directly to mysql, can you view it from web2py. In controller return db(db.person.id 0).select()