What he'd like is something like this ...
Rank File Count
-
1 File W 13
2 File L 8
3 File A 4
4 File K 2
If you keep a count of the d/l's in a db then just query your file names,
rank by d/l count, and for the rank just output the Queryname.CurrentRow
value.
For example ...
SELECT Filename, Count
FROM DOWNLOADS
ORDER BY Count
Rank
File
Count
#myQuery.CurrentRow#
#myQuery.Filename#
#myQuery.Count#
Hope this helps,
Steve
-Original Message-
From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 4:52 PM
To: CF-Talk
Subject: RE: ranking a download count.
the last sentence doesn't really make sense. you'd like to display the
files by download count, but without ordering by download count?
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
-Original Message-
From: Emmet McGovern [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 07, 2000 11:31 AM
To: CF-Talk
Subject: ranking a download count.
Im not sure how to go about this. I'm writing a download count to a
database so i can keep track of how many times each file is downloaded.
However, i'd like to display the the files ranking in a top 100 sort of list
only not in order from 1-100. How would i output their rank according to
the amount of times the file has been downloaded without listing the items
in a desc order by download count?
Thanks,
Emmet
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]