I've been having a problem with arcpy in that the simple line:
arcpy.SelectLayerByAttribute_management ("TEMP_LINES")
produces this response: Runtime error : ERROR 000358: Invalid expression Failed to execute (SelectLayerByAttribute).
I've worked out that this error only occurs when a cursor is set, like this:
lineCursor = arcpy.UpdateCursor("TEMP_LINES","","","combined_i")
Can I not use select by attribute and the cursor or do I have one of them set up wrong?
EDIT: whole code:
arcpy.MakeFeatureLayer_management (Lines,"TEMP_LINES")
lineCursor = arcpy.UpdateCursor("TEMP_LINES","","","combined_i")
for row in lineCursor:
arcpy.SelectLayerByAttribute_management ("TEMP_LINES")
arcpy.SelectLayerByLocation_management (Polygons, "INTERSECT", "TEMP_LINES")
arcpy.FeatureClassToFeatureClass_conversion (Polygons, "temp_polys")
polyCursor = arcpy.SearchCursor("temp_polys")
blocks_list = []
for row in cursor:
blocks_list.append(row.getValue("BLOCK"))
blocks_str = ', '.join(blocks_list)
lineCursor.BLOCK = blocks_str
SelectLayerByAttribute_management
– geogeek Dec 13 '13 at 16:48