topic Re: syntax for query using variable name in ArcGIS API for Python Questions https://community.esri.com/t5/arcgis-api-for-python-questions/syntax-for-query-using-variable-name/m-p/841486#M3555 <HTML><HEAD></HEAD><BODY><P>Smooth and straight. I googled, searched ... found stuff like %s, var ... but did not test the "Esri way" <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> &nbsp;Thanks!&nbsp;</P></BODY></HTML> Thu, 22 Jun 2017 19:47:09 GMT GünterDörffel 2017-06-22T19:47:09Z syntax for query using variable name https://community.esri.com/t5/arcgis-api-for-python-questions/syntax-for-query-using-variable-name/m-p/841484#M3553 <HTML><HEAD></HEAD><BODY><P>Hi,<BR data-jive-statusinputadd="true" data-jive-truncation-flag="true" />I searched for the proper syntax to do a query like this ...<BR data-jive-statusinputadd="true" data-jive-truncation-flag="true" />xxLayer.query(where = 'objectid &gt; 0')<BR data-jive-statusinputadd="true" data-jive-truncation-flag="true" />but instead of giving it the value (here 0) this should be a variable<BR data-jive-statusinputadd="true" data-jive-truncation-flag="true" />How is that done?<BR data-jive-statusinputadd="true" data-jive-truncation-flag="true" /><BR data-jive-statusinputadd="true" data-jive-truncation-flag="true" />Thanks Günter</P></BODY></HTML> Thu, 22 Jun 2017 15:46:12 GMT https://community.esri.com/t5/arcgis-api-for-python-questions/syntax-for-query-using-variable-name/m-p/841484#M3553 GünterDörffel 2017-06-22T15:46:12Z Re: syntax for query using variable name https://community.esri.com/t5/arcgis-api-for-python-questions/syntax-for-query-using-variable-name/m-p/841485#M3554 <HTML><HEAD></HEAD><BODY><P>Can you try&nbsp;</P><PRE class="language-python line-numbers"><CODE>query_result <SPAN class="operator token">=</SPAN> FeatureLayer<SPAN class="punctuation token">.</SPAN>query<SPAN class="punctuation token">(</SPAN>where <SPAN class="operator token">=</SPAN> <SPAN class="string token">'objectId &gt; '</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>layer_id<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Thu, 22 Jun 2017 17:31:35 GMT https://community.esri.com/t5/arcgis-api-for-python-questions/syntax-for-query-using-variable-name/m-p/841485#M3554 Anonymous User 2017-06-22T17:31:35Z Re: syntax for query using variable name https://community.esri.com/t5/arcgis-api-for-python-questions/syntax-for-query-using-variable-name/m-p/841486#M3555 <HTML><HEAD></HEAD><BODY><P>Smooth and straight. I googled, searched ... found stuff like %s, var ... but did not test the "Esri way" <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> &nbsp;Thanks!&nbsp;</P></BODY></HTML> Thu, 22 Jun 2017 19:47:09 GMT https://community.esri.com/t5/arcgis-api-for-python-questions/syntax-for-query-using-variable-name/m-p/841486#M3555 GünterDörffel 2017-06-22T19:47:09Z