g.ricioppo at gmail
Nov 22, 2009, 6:36 AM
Post #1 of 1
(167 views)
Permalink
|
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)
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.
K
--
http://mail.python.org/mailman/listinfo/python-list
|
