Re: Problem inserting data from form

[andreas gjersøe]

I had problems inserting data to my tables. As you mensioned, everything is running fine without any error messages. I solved my problem by adding commit .
This worked for me:

import MySQLdb

conn= MySQLdb.connect (host = "localhost",
user = "********",
passwd = "********",
db = "*****")

cursor= conn.cursor ()
cursor.execute ("INSERT INTO table1(col1, col2) VALUES('val1', 'val2')")

#Do your things here

cursor.execute ("COMMIT")
cursor.close ()
conn.close ()



Jan Paricka Wrote:
-------------------------------------------------------
> Hi Dougles,
>
> Did you manage to work out this problem?
>
> What was it?
>
> I'm asking as I do have a similar problem as you
> did.
>
> Instert into database seems to be runing fine ,
> even an id which is unique auto-incremental field
> is updated but no record is entered.
>
> I've checked all my SQL statements and they seems
> to be fine when running them manually.
>
> Thanks for letting me know.
>
> Cheers,
> Jan