topic where clause of my selectlayerbyattribute_management keeps returning error in Python Questions https://community.esri.com/t5/python-questions/where-clause-of-my-selectlayerbyattribute/m-p/455325#M35784 <HTML><HEAD></HEAD><BODY><SPAN>Refering to ArcGIS 10 Help, I have tried writting my where clause exactly as stated in the help (using quotes, brakets, etc) and I keep getting Error 000358: Invalid expression Failed to execute (SelectLayerByAttribute).&nbsp; I am running this inside arcmap.</SPAN><BR /><BR /><PRE class="plain" name="code">arcpy.SelectLayerByAttribute_management("zipcode_27012", "NEW_SELECTION", "NAME" = '27012') </PRE><DIV style="display:none;"> </DIV><BR /><BR /><SPAN>There must be something obvious I am missing.</SPAN></BODY></HTML> Tue, 26 Mar 2013 14:43:36 GMT KP 2013-03-26T14:43:36Z where clause of my selectlayerbyattribute_management keeps returning error https://community.esri.com/t5/python-questions/where-clause-of-my-selectlayerbyattribute/m-p/455325#M35784 <HTML><HEAD></HEAD><BODY><SPAN>Refering to ArcGIS 10 Help, I have tried writting my where clause exactly as stated in the help (using quotes, brakets, etc) and I keep getting Error 000358: Invalid expression Failed to execute (SelectLayerByAttribute).&nbsp; I am running this inside arcmap.</SPAN><BR /><BR /><PRE class="plain" name="code">arcpy.SelectLayerByAttribute_management("zipcode_27012", "NEW_SELECTION", "NAME" = '27012') </PRE><DIV style="display:none;"> </DIV><BR /><BR /><SPAN>There must be something obvious I am missing.</SPAN></BODY></HTML> Tue, 26 Mar 2013 14:43:36 GMT https://community.esri.com/t5/python-questions/where-clause-of-my-selectlayerbyattribute/m-p/455325#M35784 KP 2013-03-26T14:43:36Z Re: where clause of my selectlayerbyattribute_management keeps returning error https://community.esri.com/t5/python-questions/where-clause-of-my-selectlayerbyattribute/m-p/455326#M35785 <HTML><HEAD></HEAD><BODY><SPAN>Hi Kevin, </SPAN><BR /><BR /><SPAN>What type of data are your working with (i.e. shapefile, File Geodatabase feature class, Personal Geodatabase feature class)?</SPAN><BR /><BR /><SPAN>Try the following:</SPAN><BR /><BR /><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro">arcpy.SelectLayerByAttribute_management("zipcode_27012", "NEW_SELECTION", "NAME = '27012'")</PRE></BODY></HTML> Tue, 26 Mar 2013 15:15:19 GMT https://community.esri.com/t5/python-questions/where-clause-of-my-selectlayerbyattribute/m-p/455326#M35785 JakeSkinner 2013-03-26T15:15:19Z Re: where clause of my selectlayerbyattribute_management keeps returning error https://community.esri.com/t5/python-questions/where-clause-of-my-selectlayerbyattribute/m-p/455327#M35786 <HTML><HEAD></HEAD><BODY><SPAN>Simply a shapefile.</SPAN></BODY></HTML> Tue, 26 Mar 2013 15:43:01 GMT https://community.esri.com/t5/python-questions/where-clause-of-my-selectlayerbyattribute/m-p/455327#M35786 KP 2013-03-26T15:43:01Z Re: where clause of my selectlayerbyattribute_management keeps returning error https://community.esri.com/t5/python-questions/where-clause-of-my-selectlayerbyattribute/m-p/455328#M35787 <HTML><HEAD></HEAD><BODY><SPAN>The syntax I posted initially should work.</SPAN></BODY></HTML> Tue, 26 Mar 2013 18:01:38 GMT https://community.esri.com/t5/python-questions/where-clause-of-my-selectlayerbyattribute/m-p/455328#M35787 JakeSkinner 2013-03-26T18:01:38Z Re: where clause of my selectlayerbyattribute_management keeps returning error https://community.esri.com/t5/python-questions/where-clause-of-my-selectlayerbyattribute/m-p/455329#M35788 <HTML><HEAD></HEAD><BODY><SPAN>I ended having to use three(""") to get it to work.</SPAN></BODY></HTML> Thu, 28 Mar 2013 19:25:37 GMT https://community.esri.com/t5/python-questions/where-clause-of-my-selectlayerbyattribute/m-p/455329#M35788 KP 2013-03-28T19:25:37Z