Using a where clause in a search cursor

LoganBohn

Hello all, I am pretty new to programming and arcpy. I am attaching a code where I am trying to take an input country from a user and use it in the where clause to return a list of the population ranks present for that country. As it is now, it returns an error that a column was specified that does not exist. The issue is in my query, but I cannot figure out how to format it to only return results from a certain country. Don't worry about the 2nd half of the code, as I am just trying to figure out this search cursor. 

 

Thanks!!

 

 

MedianPopulationRankofCountry(txt).txt

JohannesLindner

You want the following SQL query:

CNTRY_NAME = 'Country'

To get that as a string in PYthon:

query = "CNTRY_NAME = '{}'".format(country)