Evaluation Results

1. Junior Member
Join Date
Dec 1969
Posts
7

Evaluation Results

I am working on a project in which students will log on to a website, select an Instructor, Select on of the Courses assigned to the Instructor, and then submit an evaluation about that instructor that consists of 16 questions with a 1-5 rating system. There is a comments field also. <BR><BR>In displaying the results of these evaluations, I have a query in my db that Averages the each question for the evalutaion per Instructor per Course.<BR><BR>So, let&#039;s say that I have Mrs. Martin teaching English II and that 25 students submit an evaluation for Mrs. Martin&#039;s English II class. I then display the Average of those results through this query in a chart on the website. <BR><BR>&#060;b&#062;The Problem:&#060;/b&#062; The comments... Because they are not numbers I have to exclude them from the query. But, I want to be able to make them display below the chart with the results of the query relative to the Instructor/Course that they belong to. An evaluation that had 25 submissions might have 15 comments. The numbers for the average will only be one because it is an average of the 25. How do I do this in the ASP or in my queries?

2. Senior Member
Join Date
Dec 1969
Posts
178

RE: Evaluation Results

why don&#039;t you just select comments from table where instructor = "Martin"???? Or am I missing something...<BR><BR>You can still do the averages and them display all the comments below the average....Show us some of your asp code...

3. Senior Member
Join Date
Dec 1969
Posts
5,955

In a word, use two recordsets...

...at the same time. The first is just the results for a given instructor, the second contains all the comments for all instructors. As you loop through the first and display the averages, you loop through the second as long as the comments are for the current instructor and until the next instructor&#039;s comments come up.<BR><BR>All right, that&#039;s not in one word, but the principle is clear, I hope.<BR><BR>The other way is to have the first recordset and then open a second recordset as you loop through for each instructor.<BR><BR>In any case, you&#039;ll have one loop inside the other.<BR><BR>Oliver.

4. Junior Member
Join Date
Dec 1969
Posts
7