Would anyone know why this works locally,but notremotely?

[Brown1]

This little piece of code works locally and on my old host, but will generate
an error on my new host (all running CF 6.1)

<cfquery name="getused1" datasource="JetDB">
SELECT *
FROM Used,Dealers
WHERE Used.Dealer = Dealers.Name
AND Used.City = Dealers.City
</cfquery>
<cfoutput query="getused1">#getused1.City#</cfoutput>

I get this error
Element CITY is undefined in GETUSED1.

Obviously Used.City = Dealers.City is conflicting (I know I havent the best
coding practices by using the same column name in 2 tables)
but why would it work on 2 servers but not the third? A simple setting maybe
(I hope) or total re-code??

Thank you all in advance

[Dan Bracuk]

Speaking of best coding practices, stop using select *. Specify your
fieldnames in the select clause. Select only those fields you need. Use
aliases if necessary. See if this suggestion solves this specific problem.

[Brown1]

Thanks Dan, the problem was solved by using

<cfoutput query="getused1">#getused1.dealers.City#</cfoutput>

thanks for your help

[boughtonp]

The other way you could have solved it is by doing:

SELECT used.city AS u_city, dealers.city AS d_city

Then doing #getused1.d_city# inside the CFOUTPUT