Sorting by dynamic table column heading

[welsh15soccer]

I am trying to do the same as cindypsych, in the post below. Can some one help me with my code please. Thanks in advance. I want to sort each column by clicking on the column head.
..

[Daverms]

Hi,

Whats wrong with your code mate?

[welsh15soccer]

I am trying to sort each column when it is displayed on the screen. My code keeps telling me Element TailNum is undefined in URL.

[dempster]

Your query is looking for 2 URL parameters:

WHERE "TailNum" = #URL.TailNum# ORDER BY #URL.SORTBY#

But according to the links at the top of each column, you're only passing one:

TestSort.cfm?SORTBY=Series=asc

You probably want something more like this:

TestSort.cfm?TailNum=#URL.TailNum#&SORTBY=Series

This way you pass TailNum each tyime.