This seems like an easy thing, I've checked dozens of forums, but can't find what I'm looking for.

I have a cfoutput query of results. and i just want to number the results in order 1, 2, 3 etc. I have a drop down box that will change the rank the results based on what they choose.

All I'm looking for is to show that rank depending on what the user chooses. It will always be 1, 2, 3 etc. but the record order changes depending on the drop down box. I thought it was as easy as a cfloop with a counter adding +1, but how do i mesh that with a cfoutput query. Or can I not do that.

Thanks for the help.

Not sure I completely understand.. Do You mean you want to number the results?

Like

1. Page 1

2. Page 2

3. Page 3

4. Page 4

Or do you want to some how re order the results?

sorry for the confusion.

i just want to order the results

1
2
3

ohhh ok. If you are looping through a query you just use "Current Row"



If you were looping through a plain loop (Not a query)..



Give that a shot.

Thanks a bunch! I knew it was easy. Stupid mind blocks. Sometimes the easiest thing is right in front of your face.

Thanks

Indeed! No Problem Even us experienced CF'ers hit mind blocks on the little things that are so obvoius