> 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