On 5/8/2016 11:15 AM, Chris Angelico wrote:
On Mon, May 9, 2016 at 1:06 AM, DFS <nos...@dfs.com> wrote:
On 5/8/2016 10:36 AM, Chris Angelico wrote:
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
That's what commit() does.
Yes. Even if you got an error part way through, you just blithely commit. What?!
And yes, I am flat-out boggling at this.
ChrisA
I'm boggling that you're boggling.
--
https://mail.python.org/mailman/listinfo/python-list
