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