I have a search results page where I am using the column headers as way to sort. Each time you click to header, it runs the query again and appends the URL to something like searchresults.cfm?SortBy=Price.
However, once you sort by Column Header, it returns ALL the rows, not just the results of the intial search (where you might be filtering by Price, Category, Size, etc). Below is the relevant code: <cfparam name="SortBy" default="Designer"> <CFQUERY NAME="search_results" DATASOURCE="DB"> SELECT P.ProdID, P.Designer, P.DressSize, P.Price, C.Category, C.CatID FROM Products P JOIN Category C ON P.CatID = C.CatID WHERE 0=0 <CFIF FORM.Designer IS NOT ""> AND Designer LIKE '%#FORM.Designer#%' </CFIF> <CFIF FORM.DressSize IS NOT ""> AND DressSize LIKE '%#FORM.DressSize#%' </CFIF> <CFIF FORM.Price IS NOT ""> AND Price <= #FORM.Price# </CFIF> <CFIF FORM.CatID IS NOT ""> AND C.CatID = #FORM.CatID# </CFIF> ORDER BY #sortBy# </CFQUERY> <tr> <td><a href="searchresults.cfm?SortBy=Category">Category</a>td> <td><a href="searchresults.cfm?SortBy=Designer">Designer</a></td> <td><a href="searchresults.cfm?SortBy=DressSize">Size</a></td> </tr> I know I'm missing something simple... Thanks Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:250785 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4