1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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