Can you restructure the query so that it returns Student1 Question 1 Question 3 Student2 Question 1 Question 2 Question 3
etc. Would be much easier to work with. or even: Question 1Student 1 Question 1Student 2 Question 1Student 3 Question 2Student 2 Question 2Student 3 Question 2Student 4 Question 3Student 1 Question 3Student 2 You could then sort by student, and counting questions becomes easy. Phil. ----- Original Message ----- From: "Knott, Brian" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, August 27, 2003 3:09 PM Subject: [cfaussie] Variable Problems > I have a problem setting variables. > > I have a loop of questions that contain a loop of questions. So the loops > look like this. > > Question 1 > Student 1 > Student 2 > Student 3 > Question 2 > Student 2 > Student 3 > Student 4 > Question 3 > Student 1 > Student 2 > > What I want to be able do is add up the number of questions has done. So in > the above example student 1 would be 2, student 2 would be 3. So I'm trying > to set some kind of counter inside the question loop every time a student is > found. > > My problem is that inside the loop I can say > > <cfset variables.studentXXX = student XXX + 1> > > The student number could be anything. > > So in summary just after a way to add up the number of questions a student > has answered. > > Brian Knott > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MX Downunder AsiaPac DevCon - http://mxdu.com/ > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
