Skip to main content
W
welsh15soccer
Participant
May 17, 2007
Question

Sorting by dynamic table column heading

  • May 17, 2007
  • 1 reply
  • 408 views
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.
..
This topic has been closed for replies.

1 reply

D
Daverms
Inspiring
May 17, 2007
Hi,

Whats wrong with your code mate?
W
welsh15soccerAuthor
Participant
May 17, 2007
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.
D
dempster
Inspiring
May 17, 2007
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.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices