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

OLANIYANOLAKUNLE

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.

markdenil

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'