Any help on how to properly format the where clause in the following code would be greatly appreciated. I get an Invalid Expression error despite whatever combinations I try. v is a string value. Thanks.
code:
for v in lstFCCvalues:
try:
outfeature = os.path.join(fdstarget, v + 'Roads')
if arcpy.Exists(outfeature): arcpy.Delete_management(outfeature)
where = arcpy.AddFieldDelimiters(intable, fcc) + ' = ' + v
arcpy.Select_analysis(intable, outfeature, where)
except Exception as e:
exceptionMessage(e)
sample error;
ERROR 000358: Invalid expression "FCC" = A00
Failed to execute (Select).
Solved! Go to Solution.
Well, after working on it for a couple hours, then posting it here, I got the solution on my next try. For reference, here it is;
where = arcpy.AddFieldDelimiters(intable, fcc) + ' = \'' + v + '\''
Well, after working on it for a couple hours, then posting it here, I got the solution on my next try. For reference, here it is;
where = arcpy.AddFieldDelimiters(intable, fcc) + ' = \'' + v + '\''