topic Re: parameter in arcpy in Python Questions https://community.esri.com/t5/python-questions/parameter-in-arcpy/m-p/35925#M2814 <HTML><HEAD></HEAD><BODY><P>I would also consider using the "Add Field Delimiters" function. It makes sure you have appropriate delimiters for your SQL queries.</P><P><A href="http://pro.arcgis.com/en/pro-app/arcpy/functions/addfielddelimiters.htm" title="http://pro.arcgis.com/en/pro-app/arcpy/functions/addfielddelimiters.htm" rel="nofollow noopener noreferrer" target="_blank">AddFieldDelimiters—ArcPy Functions | ArcGIS for Desktop</A> <BR />Example: <BR /><A href="https://github.com/Holisticnature/GeodesignToolkit-GIS-CityEngine-Integration-Tools/blob/master/Scripts/SplitFeaturebyAttribute.py" title="https://github.com/Holisticnature/GeodesignToolkit-GIS-CityEngine-Integration-Tools/blob/master/Scripts/SplitFeaturebyAttribute.py" rel="nofollow noopener noreferrer" target="_blank">GeodesignToolkit-GIS-CityEngine-Integration-Tools/SplitFeaturebyAttribute.py at master · Holisticnature/GeodesignToolkit…</A></P><PRE class="lia-code-sample line-numbers language-none">def constructSQLEqualityQuery(fieldName, value, dataSource): &nbsp;&nbsp;&nbsp; # Creates a workspace sensitive equality query to be used in arcpy. &nbsp;&nbsp;&nbsp; return "{0} = '{1}'".format(arcpy.AddFieldDelimiters(dataSource, fieldName), str(value))</PRE></BODY></HTML> Fri, 10 Dec 2021 21:23:40 GMT DavidWasserman 2021-12-10T21:23:40Z parameter in arcpy https://community.esri.com/t5/python-questions/parameter-in-arcpy/m-p/35922#M2811 <HTML><HEAD></HEAD><BODY><P>I am trying to create python script tool which takes parameter.</P><P></P><P>x = arcpy.GetParameterAsText(0)</P><P>arcpy.MakeFeatureLayer_management("C:/test.gdb/cities","cities_lyr", """ "STATE_NAME" = 'Idaho' """)</P><P></P><P>How to pass value of x variable for STATE_NAME instead of constant value 'Idaho' ?</P></BODY></HTML> Mon, 11 Apr 2016 05:18:00 GMT https://community.esri.com/t5/python-questions/parameter-in-arcpy/m-p/35922#M2811 jayasudha 2016-04-11T05:18:00Z Re: parameter in arcpy https://community.esri.com/t5/python-questions/parameter-in-arcpy/m-p/35923#M2812 <HTML><HEAD></HEAD><BODY><P>state_name = arcpy.GetParameterAsText(1) # just get the sql query formulated correctly or define this parameter as an SQL in the tool in the parameter type</P></BODY></HTML> Mon, 11 Apr 2016 09:49:46 GMT https://community.esri.com/t5/python-questions/parameter-in-arcpy/m-p/35923#M2812 DanPatterson_Retired 2016-04-11T09:49:46Z Re: parameter in arcpy https://community.esri.com/t5/python-questions/parameter-in-arcpy/m-p/35924#M2813 <HTML><HEAD></HEAD><BODY><PRE __default_attr="python" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14604065826728384 jive_text_macro" data-renderedposition="8_8_1332_16" jivemacro_uid="_14604065826728384"><P>arcpy.MakeFeatureLayer_management("C:/test.gdb/cities","cities_lyr", """ "STATE_NAME" = '{0}' """.format(x))</P></PRE></BODY></HTML> Mon, 11 Apr 2016 20:29:50 GMT https://community.esri.com/t5/python-questions/parameter-in-arcpy/m-p/35924#M2813 AndrewKeith3 2016-04-11T20:29:50Z Re: parameter in arcpy https://community.esri.com/t5/python-questions/parameter-in-arcpy/m-p/35925#M2814 <HTML><HEAD></HEAD><BODY><P>I would also consider using the "Add Field Delimiters" function. It makes sure you have appropriate delimiters for your SQL queries.</P><P><A href="http://pro.arcgis.com/en/pro-app/arcpy/functions/addfielddelimiters.htm" title="http://pro.arcgis.com/en/pro-app/arcpy/functions/addfielddelimiters.htm" rel="nofollow noopener noreferrer" target="_blank">AddFieldDelimiters—ArcPy Functions | ArcGIS for Desktop</A> <BR />Example: <BR /><A href="https://github.com/Holisticnature/GeodesignToolkit-GIS-CityEngine-Integration-Tools/blob/master/Scripts/SplitFeaturebyAttribute.py" title="https://github.com/Holisticnature/GeodesignToolkit-GIS-CityEngine-Integration-Tools/blob/master/Scripts/SplitFeaturebyAttribute.py" rel="nofollow noopener noreferrer" target="_blank">GeodesignToolkit-GIS-CityEngine-Integration-Tools/SplitFeaturebyAttribute.py at master · Holisticnature/GeodesignToolkit…</A></P><PRE class="lia-code-sample line-numbers language-none">def constructSQLEqualityQuery(fieldName, value, dataSource): &nbsp;&nbsp;&nbsp; # Creates a workspace sensitive equality query to be used in arcpy. &nbsp;&nbsp;&nbsp; return "{0} = '{1}'".format(arcpy.AddFieldDelimiters(dataSource, fieldName), str(value))</PRE></BODY></HTML> Fri, 10 Dec 2021 21:23:40 GMT https://community.esri.com/t5/python-questions/parameter-in-arcpy/m-p/35925#M2814 DavidWasserman 2021-12-10T21:23:40Z Re: parameter in arcpy https://community.esri.com/t5/python-questions/parameter-in-arcpy/m-p/35926#M2815 <HTML><HEAD></HEAD><BODY><P>Thanks to all for your suggestions.</P></BODY></HTML> Tue, 12 Apr 2016 08:31:05 GMT https://community.esri.com/t5/python-questions/parameter-in-arcpy/m-p/35926#M2815 jayasudha 2016-04-12T08:31:05Z