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
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>
