How to make a selection in a map (mxd) from a stand-alone python script?

Ulises

I have a map document created in ArcGIS 10 that is access daily by our users.  Is there any way to run a selection (by location or attribute) from a stand alone script and save the mxd so users see the updated selection when they open the map document?  We want to run the script every night.

Thanks

JeffreyBarrette

Yes.  Have you tried something like:

import arcpy
mxd = arcpy.mapping.MapDocument("path to mxd")
lyr = arcpy.mapping.ListLayers(mxd, "layer name")[0]
arcpy.SelectLayerByAttribute_management(lyr, "NEW_SELECTION", "some query")
mxd.save()

#If you don't want to save the selection to the existing MXD, try saving it to another file:
mxd.saveACopy("path to new MXD")

Jeff