|
sr_erick
Senior Member
USA
1318 Posts |
 Posted - 01 March 2005 : 02:50:36
|
Hello all, what I'm looking for is a solution to my problem. I want to display a calculated average from another table along side the username in the forum with every post that user makes. The only problem is I cannot use an aggragete function such as avg(RATE) in with the main queries which call the topic and all the replies because of the nText fields.
What I have is a table with three fields:
-The user being rated
-The user making the rating
-The rating that user gave (1-5)
If I remove all of the nText fields from the query everything works as I want but I need to get the reply text too.  I don't want to send 20 queries per page of replies to the database just for an average member rating. There has to be some clever way around this.
Any ideas? The file is topic.asp, if you know snitz you'll know which queries I'm talking about. One to get the topic and the other to get all the replies. |
Erick
Snowmobile Fanatics
|
Edited by - sr_erick on 01 March 2005 02:51:25 |
|
Topic Locked
