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
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
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?
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,
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
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
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,
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
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
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.
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()
11 matches
Mail list logo