2 Replies Latest reply on May 11, 2006 4:16 AM by boughtonp

    order by

    RyanG24 Level 1
      Gday, i have the following query order by code below, this works but if i add more cfifs to the code then it stops working

      not sure if this is th right way to do this?

      i have 6 form options which when selected i want the value to be the order by clause, also i need to have a is defined somehow

      ORDER BY
      <CFIF FORM.Order IS '100S'>Hundred DESC<CFELSE>BB.TotalRuns DESC</CFIF>,
      <CFIF FORM.Order IS 'Highest'>HighestScore DESC<CFELSE>BB.TotalRuns DESC</CFIF>