On 5/8/2016 10:36 AM, Chris Angelico wrote:
On Mon, May 9, 2016 at 12:25 AM, DFS <[email protected]> wrote:for category,name,street,city,state,zipcode in ziplists: try: db.execute(cSQL, vals) except (pyodbc.Error) as programError: if str(programError).find("UNIQUE constraint failed") > 0: dupeRow = True dupes +=1 print " * duplicate address found: "+name+", "+street else: pyodbcErr = True print "ODBC error: %s " % programError conn.commit() --------------------------------------------------------------------... and then you just commit???!? ChrisA
That's what commit() does. -- https://mail.python.org/mailman/listinfo/python-list
