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

Reply via email to