AnsweredAssumed Answered

I'M GETTING THIS ERROR "TypeError: cannot concatenate 'str' and 'int' objects"

Question asked by GISGURU_001 on Jul 2, 2013
Latest reply on Jul 2, 2013 by GISGURU_001
  • Comment • 4
I was trying to construct the sql statement below to label a feature

lyr = arcpy.mapping.ListLayers(mxd, "Line_Clip")[0] for lblClass in lyr.labelClasses:     lblClass.SQLQuery = '"ParcelID"' + "=" + str(val) + "AND" + "Bearing" + ">" + 180 TypeError: cannot concatenate 'str' and 'int' objects


Please any help, thank you.
mdenil
mdenil Jul 2, 2013 7:46 AM
Correct Answer
To start, try casting the 180 to a str
str(180)

You might want to add some spaces in the string you are building
val = 100
'"ParcelID"' + "=" + str(val) + "AND" + "Bearing" + ">" + str(180)
yeilds
"ParcelID"=100ANDBearing>180

try
val = 100
'"ParcelID" = ' + str(val) + ' AND "Bearing" > ' + str(180)
which gives you
'"ParcelID" = 100 AND "Bearing" > 180'
See the reply in context
No one else had this question

Outcomes