Re: mysqldb duplicate entry error handling

2007-02-02 Thread baur79
thanks John this solves my problem except MySQLdb.IntegrityError, message: thanks everybody again Baurzhan Zhakashev Kazakhstan / Shymkent city -- http://mail.python.org/mailman/listinfo/python-list

Re: mysqldb duplicate entry error handling

2007-02-01 Thread John Nagle
Dennis Lee Bieber wrote: > On 1 Feb 2007 10:17:31 -0800, "baur79" <[EMAIL PROTECTED]> declaimed the > following in comp.lang.python: >>IntegrityError: (1062, "Duplicate entry '[EMAIL PROTECTED]' for key 1") > > So show us the schema for the database... My take: Your database > ALREADY HAS a

Re: mysqldb duplicate entry error handling

2007-02-01 Thread Chris Mellon
On 1 Feb 2007 10:51:09 -0800, baur79 <[EMAIL PROTECTED]> wrote: > now it gives this error > > except IntegrityError, NameError: > NameError: global name 'IntegrityError' is not defined > > any idea > i have python 2.3.2 installed > IntegrityError will most likely be defined in the namespace of

Re: mysqldb duplicate entry error handling

2007-02-01 Thread baur79
now it gives this error except IntegrityError, NameError: NameError: global name 'IntegrityError' is not defined any idea i have python 2.3.2 installed -- http://mail.python.org/mailman/listinfo/python-list

Re: mysqldb duplicate entry error handling

2007-02-01 Thread Chris Mellon
On 1 Feb 2007 10:17:31 -0800, baur79 <[EMAIL PROTECTED]> wrote: > Hi guys > > > i try to run this code in loop and to pass even the entry is > duplicated > > def email_insert_in_db(email): > sql="INSERT INTO emails (email) values ('%s') "%(email) > db=_mysql.connect(host = "localhost", user = d