Coldfusion query ranked by order

Discussion in 'Programming' started by lespaul00, Oct 22, 2010.

  1. #1
    Hello,

    I have a simply query that returns 36 results in order based on a database field's value. How do I include a column in the output table that lists the order? (example: 1, 2, 3, 4, ... 36)?


    Recordcount displays 36 for all rows... not, 1, 2, 3, 4, ...


    Thanks
     
    lespaul00, Oct 22, 2010 IP
  2. cfStarlight

    cfStarlight Peon

    Messages:
    398
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Wrong variable. Try #queryname.currentRow#
     
    cfStarlight, Oct 23, 2010 IP