On Mon, May 9, 2016 at 12:25 AM, DFS <nos...@dfs.com> 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
--
https://mail.python.org/mailman/listinfo/python-list
