topic Re: I'M GETTING THIS ERROR "TypeError: cannot concatenate 'str' and 'int' objects" in Python Questions

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

OLANIYANOLAKUNLE — Tue, 02 Jul 2013 14:35:32 GMT

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.

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

LindseyWood — Tue, 02 Jul 2013 14:43:56 GMT

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

I believe it is your 180 value its an integer make the whole thing a variable like you would want it to look to sql then pass that to lblCalss.SQLQuery.

query = ' %s = %s AND Bearing > 180' %(ParcleID,val)

http://stackoverflow.com/questions/1225637/python-string-formatting

I like the c formatting way but there are many that would make it easier.

or just str(180)

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

markdenil — Tue, 02 Jul 2013 14:46:21 GMT

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'

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

RhettZufelt — Tue, 02 Jul 2013 15:33:06 GMT

This works.

lblClass.SQLQuery = '"ParcelID"' + "=" + str(val) + " AND " + '"Bearing"' + " > " + "180"

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

OLANIYANOLAKUNLE — Tue, 02 Jul 2013 17:31:14 GMT

Thanks Y'All mdenil, lmwood & rzufelt you guys are the BEST.....

topic Re: I'M GETTING THIS ERROR "TypeError: cannot concatenate 'str' and 'int' objects" in Python Questions

I'M GETTING THIS ERROR &quot;TypeError: cannot concatenate 'str' and 'int' objects&quot;

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

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

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

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

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