Select Records

NoahHuntington

I am attempting to prepare script which will be used for script tool.
First, I am only interested in selecting features then intend on appending zoom to selected routine to the end of code shown here. 
Having said that I may not even be using the correct tool (select_analysis) but am unsure of one that allows for selection only.

Regardless if I could nail down the syntax I am confident I could switch tools effectively.  Could someone suggest a better tool and

help with debugging.

Thanks in advance...

# This script runs the Select tool. The user supplies the input
import arcpy

# Get the input parameters for the Select tool
infeatures = arcpy.GetParameterAsText(0)
userinput = arcpy.GetParameterAsText(1)
    
# Run the Select tool
arcpy.Select_analysis(infeatures, "NEW_SELECTION", '\Job_Num\" = %s' % userinput)

NoahHuntington

See this Help topic: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//000v00000051000000
Try using the featurelayer's SQL 1st... You may "have to" use the SelectLayerByAttribute tool though... I am not totally familiar with the arcpy.mapping module.

You have been quite helpful, thanks again.  How should the variable syntax (type string?) look in the selectbyattribute tool; similar to what you did in the makefeaturelayer where clause?  still not quite there.

Here is what I have...

# This script runs the Select tool. The user supplies the input
import arcpy

#Set the workspace
arcpy.env.workspace = "G:\\PRAD\\PRAD_v10.1.gdb"

#Retrieve input
userinput = arcpy.GetParametersAsText(0)

# Make a layer from the feature class based on whereclause from input
arcpy.MakeFeatureLayer_management ("tax_acct", "lyr", "Job_Num = " + str(userinput))

# Select that layer
arcpy.SelectLayerByAttribute_management("lyr", "NEW_SELECTION")

#Zoom to selected
mxd = arcpy.mapping.MapDocument('CURRENT')
df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0]
df.zoomToSelectedFeatures()
df.scale = df.scale * 1.1
arcpy.RefreshActiveView()

# Clear the selection and refresh the active view
arcpy.SelectLayerByAttribute_management(lyr, "CLEAR_SELECTION")
arcpy.RefreshActiveView()