[CFTALKTor] Weighted average

[Mark D'Souza]

Title: Message

Hey everyone:   I'm hoping somebody can help me come up with the most efficient solution to my problem.  I currently have a voting system set up with voting values of 1 to 10 given to any item.  Users can view the items by rank based on the average vote.  I need to be able to weight the results by assigning higher values to each vote.  For example:   1 = 100 pts 2 = 75 pts 3 = 50 pts 4 = 25 pts 5 = 20 pts 6 = 15 pts 7 = 10 pts 8 = 5 pts   At anytime, the weighted values will change so I cannot just apply the weighted values at the time the vote is being cast and save this value to the database.  I need to apply the weighted value to the vote from within or after I have pulled the votes using a query.  Before the weighted value was required I had this:   select avg(vote) as average_vote from votelist group by vote order by vote   Easily handled with a simple SQL statement but now I think I'm going to have to set-up an array to deal with it and loop through the array to apply the weighted values and then average it out.  I'm really hoping to avoid this.  Any help would be greatly appreciated.   Mark.   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bob Keleher Sent: March 19, 2002 6:13 PM To: [EMAIL PROTECTED] Subject: Re: [CFTALKTor] HTTP Header Paul, Any chance your action page calls cflocation? We found that in some circumstances that would cause the same problem for IE browsers. We fixed it by using a custom cf_location tag available from the tag gallery (also allows setting cookies in same call). Bob. ----- Original Message ----- From: Paul Giroux - Sympatico To: [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 11:43 AM Subject: [CFTALKTor] HTTP Header When I submit a form on one particular page, I get the following HTTP header info. being dumped at the top of my page:   HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Tue, 19 Mar 2002 16:24:47 GMT Connection: close Content-type: text/html Page-Completion-Status: Normal Set-Cookie: CFID=211502; path=/; Set-Cookie: CFTOKEN=87214107; path=/;   Does anyone know specifics on how to work around this.  It's happened to another member of our team before and he had to go rebuild his forms and rename his input name's and it seemed to fix it.  I'd love to know if this is what I really need to do or if there's a simple, obvious solution that I'm missing.   Paul