nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

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.

Trouver plus de publications taguées avec

Accepted answers

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'

All comments

OLANIYANOLAKUNLE

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

rzufelt

This works.

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

markdenil

LindseyWood

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)

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.