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
problem come from mysql ou connection or web2py or even a bug in web2py...
Richard
It should be like this for mysql
On Wed, Jul 13, 2011 at 2:12 PM, Ismael Alejandro <[email protected]>wrote:
> db.define_table('person',
> Field('name','string'))
>
>
> On Wed, Jul 13, 2011 at 1:11 PM, Richard Vézina <
> [email protected]> wrote:
>
>> Would you show your model?
>>
>> Richard
>>
>>
>> On Wed, Jul 13, 2011 at 2:08 PM, Ismael Alejandro <[email protected]
>> > wrote:
>>
>>> Not working :(
>>>
>>>
>>> On Wed, Jul 13, 2011 at 1:02 PM, Richard Vézina <
>>> [email protected]> wrote:
>>>
>>>> Maybe you forgot : db.commit()
>>>>
>>>> Richard
>>>>
>>>>
>>>> On Wed, Jul 13, 2011 at 1:59 PM, Ismael Alejandro <
>>>> [email protected]> wrote:
>>>>
>>>>> well, nothing is inserted
>>>>>
>>>>>
>>>>> 2011/7/13 Kenneth Lundström <[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
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
