Grabbing highest level output

[kensington43]

I have an output of three different possible values (in a multiple form select area) from my field value called location where the record output could be all of these three values: City, County, State.
State would be the highest level, then County and then City.
I need to set one Page Header where I take just the highest level and make that the Page Header value.

So If I have this output from my Access 2000 Database on a Cold Fusion page:
RecordOne City
RecordTwo County
The header on the page will be County.

If my results come back with this:
RecordOne State
RecordTwo City
The header will be State.

If this:
RecordOne County
RecordTwo State
RecordThree City
The header will be State.

I tried this but it not working:

<cfquery name="theQry" datasource="dsnHere"> 
select *
from tableOne
where location = '#FORM.location#'
</cfquery>

<cfset pageHeader = "">
<cfoutput query="theQry">
<cfif location eq "state">
    <cfset pageHeader = "state">
<cfelseif location eq "county">
    <cfset pageHeader = "county">
<cfelseif location eq "city">
    <cfset pageHeader = "city">
<cfelse>
    <cfset pageHeader = "none">
</cfif>

Page Header = #pageHeader#

Results:<br>
#id#    #location#

</cfoutput>

Please advise because the Page Header doesnt seem to output the highest level.