Below is the code on my edit page. I want it to show only the data that I have clicked the edit button on. I click on one row only but then it shows all of the data. Can anyone see what's wrong with the code? I guess there must be some condition on the query, right? But then it shows all of the data.
<cfquery name="UpdateCity" datasource="test">
Select name, countrycode, population
from city
</cfquery>
This is the other page after I click the edit button:
