Arcpy select more than one record

Question

I'm working with ArcGIS 10.2. I used this code to select one record of an attribute table:

import arcpy
# Set the workspace
env.workspace = "F:ArcGIS\Trab\Model\Lin_150_tr.shp"
# Make a layer from the feature class
arcpy.MakeFeatureLayer_management("Lin_150_tr", "lyr5") 

arcpy.SelectLayerByAttribute_management("lyr5", "NEW_SELECTION", ' "FID" = 2 ')

And it works! Now I need to select no one record but some records of the same table, so I used a list of values and a loop:

import arcpy
env.workspace = "F:ArcGIS\Trab\Model\Lin_150_tr.shp"
arcpy.MakeFeatureLayer_management("Lin_150_tr", "lyr5")  

crit_150=[2,10,200,323,349,384,433]
for a in crit_150: 
    arcpy.SelectLayerByAttribute_management("lyr5", "NEW_SELECTION", ' "FID" = a ')

But it gives me an error:

Runtime error  Traceback (most recent call last):   File "<string>", line 21, in <module>   File "c:\program files (x86)\arcgis\desktop10.2\arcpy\arcpy\management.py", line 6494, in SelectLayerByAttribute     raise e ExecuteError: ERROR 000358: Invalid expression Failed to execute (SelectLayerByAttribute).

How can I do this?

Answer 1

a is considered as part of the string ' "FID" = a '. The variable a shouldn't be part of the string expression. Instead you can use this notation for example, making use of the python string.format() function:

arcpy.SelectLayerByAttribute_management("lyr5", "NEW_SELECTION", """"FID" = {}""".format(a))

I doubt the field delimiters are necessary here, """FID = {}""".format(a) is probably fine as well.

EDIT

If you want to select to select all rows with values from your list at once, use this expression:

import arcpy
arcpy.MakeFeatureLayer_management(r"F:ArcGIS\Trab\Model\Lin_150_tr.shp", "lyr5")  

arcpy.SelectLayerByAttribute_management("lyr5", "NEW_SELECTION", """FID IN (2,10,200,323,349,384,433)""")

Answer 2

Instead of hard coding the list of values (like @GISGe), I would build a string and pass it as variable:

import arcpy
arcpy.MakeFeatureLayer_managemen(r"F:\ArcGIS\Trab\Model\Lin_150_tr.shp", "lyr5")   

crit_150=[2,10,200,323,349,384,433]
crit_150_str = ','.join(str(val) for val in crit_150)
arcpy.SelectLayerByAttribute_management("lyr5", "NEW_SELECTION", '"FID" IN ({})'.format(crit_150_str))