I want to allow my users to filter my table by each column by clicking on the header. I am displaying the data from a query and then outputing it dynamically. I want to pass the table name to sort by in the URL and also pass any other URL variables that exist in the QUERY_STRING CGI variable.
The problem is that if I just use this: href="page.cfm?#QUERY_STRING#&orderby=fieldname" the next time a person clicks on a header from the same page their will be duplicate "orderby" values and it will mess up my query. Is there an easy way to trim out the orderby value from the QUERY_STRING? I figured that someone probably has run into this before, thanks!