topic Re: Local variables in SQL statement of Python GIS in Python Questions https://community.esri.com/t5/python-questions/local-variables-in-sql-statement-of-python-gis/m-p/331680#M25785 <HTML><HEAD></HEAD><BODY><SPAN>Thanks Logan,</SPAN><BR /><BR /><SPAN>That solved.</SPAN></BODY></HTML> Fri, 28 Oct 2011 13:48:15 GMT xiaojiabao 2011-10-28T13:48:15Z Local variables in SQL statement of Python GIS https://community.esri.com/t5/python-questions/local-variables-in-sql-statement-of-python-gis/m-p/331678#M25783 <HTML><HEAD></HEAD><BODY><SPAN>What is the appropriate format to use local variables in SQL statements under python GIS?</SPAN><BR /><BR /><SPAN>I came across error messages when I'm running the following:</SPAN><BR /><BR /><SPAN>bas=24</SPAN><BR /><SPAN>gp.Select(input, Output_Feature_Class, "\"BAS\"= bas")</SPAN><BR /><BR /><SPAN>However, it is ok if I run: gp.Select(input, Output_Feature_Class, "\"BAS\"= 24")</SPAN><BR /><BR /><SPAN>Appreciate any potential help.</SPAN><BR /><BR /><SPAN>Xi</SPAN></BODY></HTML> Thu, 27 Oct 2011 20:27:21 GMT https://community.esri.com/t5/python-questions/local-variables-in-sql-statement-of-python-gis/m-p/331678#M25783 xiaojiabao 2011-10-27T20:27:21Z Re: Local variables in SQL statement of Python GIS https://community.esri.com/t5/python-questions/local-variables-in-sql-statement-of-python-gis/m-p/331679#M25784 <HTML><HEAD></HEAD><BODY><SPAN>You can't use local variable names directly -- you have to use </SPAN><A href="http://docs.python.org/release/2.6.5/library/stdtypes.html#string-formatting-operations" rel="nofollow noopener noreferrer" target="_blank">string formatting</A><SPAN> or concatenation.</SPAN><BR /><BR /><SPAN>E.g.</SPAN><BR /><BR /><PRE class="lia-code-sample line-numbers language-none"> bas=24 whereClause = "\"BAS\"= %d" % (bas) gp.Select(input, Output_Feature_Class, whereClause)</PRE></BODY></HTML> Sat, 11 Dec 2021 15:42:18 GMT https://community.esri.com/t5/python-questions/local-variables-in-sql-statement-of-python-gis/m-p/331679#M25784 LoganPugh 2021-12-11T15:42:18Z Re: Local variables in SQL statement of Python GIS https://community.esri.com/t5/python-questions/local-variables-in-sql-statement-of-python-gis/m-p/331680#M25785 <HTML><HEAD></HEAD><BODY><SPAN>Thanks Logan,</SPAN><BR /><BR /><SPAN>That solved.</SPAN></BODY></HTML> Fri, 28 Oct 2011 13:48:15 GMT https://community.esri.com/t5/python-questions/local-variables-in-sql-statement-of-python-gis/m-p/331680#M25785 xiaojiabao 2011-10-28T13:48:15Z