That worked. Dont know what the hell I am doing sometimes.
Doug B. ----- Original Message ----- From: "Charles Sheehan-MIles" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Tuesday, November 21, 2006 7:45 PM Subject: Re: What is wrong with this query? > I think so. When you do the order by, should it be something like this > (assuming you are ordering by the ...adversements.city column)? > > ORDER BY #APPLICATION.DBPRE#Advertisements.#ARGUMENTS.SORTYBY# > #ARGUMENTS.SORTDIRECTION# > > O > > > On 11/21/06 9:37 PM, "Doug Brown" <[EMAIL PROTECTED]> 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? > > > > Query > > > > SELECT #APPLICATION.DBPRE#MemberProfile.RscreenName, > > #APPLICATION.DBPRE#Advertisements.AdID, > > #APPLICATION.DBPRE#Advertisements.MemberID, > > #APPLICATION.DBPRE#Advertisements.CategoryID, > > #APPLICATION.DBPRE#Advertisements.SCategoryID, > > #APPLICATION.DBPRE#Advertisements.ItemPhoto, > > #APPLICATION.DBPRE#Advertisements.SKUName, > > #APPLICATION.DBPRE#Advertisements.Price, > > #APPLICATION.DBPRE#Advertisements.AQuantity, > > #APPLICATION.DBPRE#Advertisements.State, > > #APPLICATION.DBPRE#Advertisements.County, > > #APPLICATION.DBPRE#Advertisements.City > > FROM #APPLICATION.DBPRE#Advertisements > > INNER JOIN #APPLICATION.DBPRE#MemberProfile > > ON #APPLICATION.DBPRE#Advertisements.MemberID = > > #APPLICATION.DBPRE#MemberProfile.MemberID > > WHERE #APPLICATION.DBPRE#Advertisements.Status = <cfqueryparam > > cfsqltype="CF_SQL_BIT" value="#Val(ARGUMENTS.Status)#"> > > > > > > offending code > > > > <cfif Len(ARGUMENTS.search_visitor_city) gt 0> > > AND #APPLICATION.DBPRE#Advertisements.State = <cfqueryparam > > cfsqltype="CF_SQL_CHAR" value="'#Trim(ARGUMENTS.search_state)#'"> > > AND #APPLICATION.DBPRE#Advertisements.City = <cfqueryparam > > cfsqltype="CF_SQL_VARCHAR" value="'#Trim(ARGUMENTS.search_visitor_city)#'"> > > </cfif> > > > > ORDER BY #ARGUMENTS.sortBy# > > #ARGUMENTS.sortDirection# > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:261358 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
