topic Re: Problem with select by attributes in Python Questions https://community.esri.com/t5/python-questions/problem-with-select-by-attributes/m-p/608006#M47453 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">I've got problem with python to use select by attributes to my layer called "World Cities". I type this script:<BR /><BR />arcpy.SelectLayerByAttribute_management ("World Cities","NEW_SELECTION","CITY_NAME" = 'Abancay')<BR /><BR />and&nbsp; I see : <BR />Runtime error SyntaxError: keyword can't be an expression (&lt;string&gt;, line 1)<BR /><BR />When I'm trying this tool in arcgis not by python everything is ok, but in script I see this error. Please help!</BLOCKQUOTE><BR /><BR /><SPAN>The expression part of your script is not enclosed in quotes properly.&nbsp; I believe "CITY_NAME" = 'Abancay' has to be "\"CITY_NAME\" = 'Abancay'" or '"CITY_NAME" = \'Abancay\''</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>Try:</SPAN><BR /><BR /><SPAN>arcpy.SelectLayerByAttribute_management ("World Cities","NEW_SELECTION","\"CITY_NAME\" = 'Abancay'")</SPAN><BR /><BR /><SPAN>or:</SPAN><BR /><BR /><SPAN>arcpy.SelectLayerByAttribute_management ("World Cities","NEW_SELECTION",'"CITY_NAME" = \'Abancay\'')</SPAN></BODY></HTML> Sat, 18 Jan 2014 20:34:00 GMT RichardFairhurst 2014-01-18T20:34:00Z Problem with select by attributes https://community.esri.com/t5/python-questions/problem-with-select-by-attributes/m-p/608004#M47451 <HTML><HEAD></HEAD><BODY><SPAN>I've got problem with python to use select by attributes to my layer called "World Cities". I type this script:</SPAN><BR /><BR /><SPAN>arcpy.SelectLayerByAttribute_management ("World Cities","NEW_SELECTION","CITY_NAME" = 'Abancay')</SPAN><BR /><BR /><SPAN>and&nbsp; I see : </SPAN><BR /><SPAN>Runtime error SyntaxError: keyword can't be an expression (&lt;string&gt;, line 1)</SPAN><BR /><BR /><SPAN>When I'm trying this tool in arcgis not by python everything is ok, but in script I see this error. Please help!</SPAN></BODY></HTML> Sat, 18 Jan 2014 17:48:44 GMT https://community.esri.com/t5/python-questions/problem-with-select-by-attributes/m-p/608004#M47451 JoannaKIlian 2014-01-18T17:48:44Z Re: Problem with select by attributes https://community.esri.com/t5/python-questions/problem-with-select-by-attributes/m-p/608005#M47452 <HTML><HEAD></HEAD><BODY><SPAN>it seems you answered your own question...do you want to share it?</SPAN></BODY></HTML> Sat, 18 Jan 2014 18:03:42 GMT https://community.esri.com/t5/python-questions/problem-with-select-by-attributes/m-p/608005#M47452 DanPatterson_Retired 2014-01-18T18:03:42Z Re: Problem with select by attributes https://community.esri.com/t5/python-questions/problem-with-select-by-attributes/m-p/608006#M47453 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">I've got problem with python to use select by attributes to my layer called "World Cities". I type this script:<BR /><BR />arcpy.SelectLayerByAttribute_management ("World Cities","NEW_SELECTION","CITY_NAME" = 'Abancay')<BR /><BR />and&nbsp; I see : <BR />Runtime error SyntaxError: keyword can't be an expression (&lt;string&gt;, line 1)<BR /><BR />When I'm trying this tool in arcgis not by python everything is ok, but in script I see this error. Please help!</BLOCKQUOTE><BR /><BR /><SPAN>The expression part of your script is not enclosed in quotes properly.&nbsp; I believe "CITY_NAME" = 'Abancay' has to be "\"CITY_NAME\" = 'Abancay'" or '"CITY_NAME" = \'Abancay\''</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>Try:</SPAN><BR /><BR /><SPAN>arcpy.SelectLayerByAttribute_management ("World Cities","NEW_SELECTION","\"CITY_NAME\" = 'Abancay'")</SPAN><BR /><BR /><SPAN>or:</SPAN><BR /><BR /><SPAN>arcpy.SelectLayerByAttribute_management ("World Cities","NEW_SELECTION",'"CITY_NAME" = \'Abancay\'')</SPAN></BODY></HTML> Sat, 18 Jan 2014 20:34:00 GMT https://community.esri.com/t5/python-questions/problem-with-select-by-attributes/m-p/608006#M47453 RichardFairhurst 2014-01-18T20:34:00Z