Proper syntax for where clause

Zeke — Thu, 28 Aug 2014 19:58:56 GMT

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).

Re: Proper syntax for where clause

Zeke — Thu, 28 Aug 2014 20:18:18 GMT

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 + '\''

topic Proper syntax for where clause in Python Questions

Proper syntax for where clause

Re: Proper syntax for where clause