Doug Brown wrote:
> I have a sort function on a search results page that is giving me an
> Ambiguous column name error, and for the life of me I do not know
> why. I can sort by price, SKUName and photo just fine but cannot sort
> by city or state. I have a city and state column in the table I am
> joining with, but cannot see that would be the problem. Am I wrong?
>
<snip>
>
> ORDER BY #ARGUMENTS.sortBy# #ARGUMENTS.sortDirection#
>
If the city and state are in more than one table, then whatever is in
that ARGUMENTS.sortby would need to be scoped with the table name. I'm
guessing that ARGUMENTS.sortby = "state, city" and it needs to be
something like...
ARGUMENTS.sortby = "#APPLICATION.DBPRE#Advertisements.State,
#APPLICATION.DBPRE#Advertisements.City"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261353
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
