Kill Joy wrote:
> Hi all.
>
> I have a mod_python script with two query:
>
> cursor = db.cursor()
>
> sql = 'SELECT * FROM users where username=\'' + username +'\''
> cursor.execute(sql)
> result = cursor.fetchall()
> num = int(cursor.rowcount)
>
> if num == 0 :
> sql2 = 'insert into users values (null, \'' + username + '\',
> \'' +
> password +'\', \'no\',\'fdfdf\')'
> cursor.execute(sql2)
db.commit()
> warning = "Registration ok"
>
> else :
> warning = "EXIST!"
>
> The first query is executed... but not the second. It doesn't insert.
> Why?
> I'm a newbie... sorry.
>
> Many thanks.
>
I added db.commit() after cursor.execute(sql2).
--
http://mail.python.org/mailman/listinfo/python-list
