badruddin

Using Select (Analysis) in Python

Discussion created by badruddin on Mar 16, 2011
Latest reply on Mar 16, 2011 by badruddin
I'm trying to use SELECT  (arcpy.analysis.Select) in Python and it does not work. Here is my code:
>>>arcpy.analysis.Select("USA","Test1",'"STATE_NAME" = "Maine"')

It gives me the following error message:
"Error executing function. A column was specified that does not exist. A column was specified that does not exist. Failed to execute (Select)"

Surprisingly, it works if I use a numeric field for the where_clause as shown below!
arcpy.analysis.Select("USA","Test1",'"POP2000" > 10000000')

Please let me know what I'm doing wrong.

Thanks.

AZM Badruddin

Outcomes