select by attribute python script, greater than integer variable, cannot concatenate with string

MichaelFletcher1 — Wed, 19 Apr 2017 04:45:26 GMT

Hi Everyone, I am trying to write a query that selects by attribute, looping through different files, but have run into a snag because the variable is numeric and I wish to select values less than that number. If I convert the number to string, it is not a valid query. Code below:

while row:

FromVar = str(row.Fromage)

Fromcommand = "'" + "FROMAGE" + "<" + "FromVar" + "'"

print Fromcommand

row = rows.next()

arcpy.SelectLayerByAttribute_management("Multipoint Yellowstone plus a little Shatsky", "SUBSET_SELECTION", Fromcommand)

Re: select by attribute python script, greater than integer variable, cannot concatenate with string

DanPatterson_Retired — Sun, 12 Dec 2021 01:44:31 GMT

"\"FROMAGE\" < {}".format(1) as in...

>>> for i in range(3):   print("\"FROMAGE\" < {}".format(i))
... 
"FROMAGE" < 0
"FROMAGE" < 1
"FROMAGE" < 2
 
‍‍‍‍‍‍

the trick is in the escape encoding and the format formatter

topic Re: select by attribute python script, greater than integer variable, cannot concatenate with string in Data Management Questions

select by attribute python script, greater than integer variable, cannot concatenate with string

Re: select by attribute python script, greater than integer variable, cannot concatenate with string