AnsweredAssumed Answered

Update Cursor parsing error

Question asked by clintoncooper on Oct 22, 2013
Latest reply on Oct 23, 2013 by clintoncooper
I am putting together some snippets of code and running into a parsing error: Parsing error SyntaxError: invalid syntax (line 8).  The error seems to be on line: updateRows = arcpy.da.UpdateCursor(mainTbl, ["FULL_ADDRESS","FREQUENCY"])
   I have tried all types of fixes, but cannot find the problem.  I am running on 10.2

import arcpy  lutTbl = r"Database Servers\CLINTONCOOPER_SQLEXPRESS.gds\VOTERS_20133 (VERSION:dbo.DEFAULT)\VOTERS_20133.DBO.frequency" mainTbl = r"Database Servers\CLINTONCOOPER_SQLEXPRESS.gds\VOTERS_20133 (VERSION:dbo.DEFAULT)\VOTERS_20133.DBO.OHIO_VOTERS_GEOCODE_OCT142013_small"  lutDict = dict([(r.FULL_ADDRESS, (r.FREQUENCY)) for r in arcpy.da.SearchCursor(lutTbl, ["FULL_ADDRESS","FREQUENCY"])  updateRows = arcpy.da.UpdateCursor(mainTbl, ["FULL_ADDRESS","FREQUENCY"]) for updateRow in updateRows:     nameValue = updateRow.FULL_ADDRSS      if nameValue in lutDict:         updateRow[1] = lutDict[nameValue][0]  #Address     else:     updateRows.updateRow(updateRow) del updateRow, updateRows 

Outcomes