AnsweredAssumed Answered

Proper syntax for where clause

Question asked by recurvata on Aug 28, 2014
Latest reply on Aug 28, 2014 by recurvata

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

Outcomes