On 22 Nov, 16:00, Gerald Walker <geraldwalk...@gmail.com> wrote: > 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).
ohhh... many thanks many thanks. Gius. -- http://mail.python.org/mailman/listinfo/python-list
