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
--
https://mail.python.org/mailman/listinfo/python-list
