I have a page that allows our instructors to enter marks and comments for students in their courses. The page is displayed fine when the instructor doesn't have many students in his course. For courses where there are a lot of students, the dropdown boxes are not displayed. Aside from changing it so that I only display say 10 students at a time, is there another way that I can display this much data without running out of system resources on the client?
here is the code for it
<cfoutput query="getStudentData">
<cfset counterVariable = counterVariable + 1>
<cfset studentNumbers[#counterVariable#] = #cyb_student_id#>
<cfset studentComments[#counterVariable#] = #cyb_strengths#>
<tr>
<td bgColor=yellow><div align=center><strong>Student Name</strong></div></td>
<td bgColor=yellow><div align=center><strong>Midterm Mark</strong></div></td>
<td bgColor=yellow><div align=center><strong>Final Mark</strong></div></td>
<td colspan=2 bgColor=yellow><div align=center><strong>Instructors Comments</strong></div></td>
</tr>
<tr>
<input type=hidden name="studentNumber_#counterVariable#" value = #cyb_student_id#>
<input type=hidden name="courseName_#counterVariable#" value = '#cyb_course_desc#'>
<td><input type=hidden name="LastName_#counterVariable#" value="#cyb_last_name#"><input type=hidden name="FirstName_#counterVariable#" value="#cyb_first_name#"><FONT size=4 color=mediumblue>#cyb_last_name# #cyb_first_name#</font></td>
<td><div align=center><input type=text name="Midterm_#counterVariable#" value="#cyb_Midterm_mark#" size=10></div></td>
<td><div align=center><input type=text name="FinalMark_#counterVariable#" value="#cyb_final_mark#" size=10></div></td>
<td colspan = 2><div align=center><textarea name="comment_#counterVariable#" cols=20>#studentComments["#counterVariable#"]#</textarea><a href='Comments.asp?id=#cyb_student_id#&oid=#oid#&course=#course#'><img src="images/commentButton.png"></a></div></td>
</tr>
<tr>
<td bgColor=yellow><strong><font size=2><div align=center>Works<br>Independently</div></font></strong></td>
<td bgColor=yellow><strong><font size=2><div align=center>Team Work</div></font></strong></td>
<td bgColor=yellow ><strong><font size=2><div align=center>Organization</div></font></strong></td>
<td bgColor=yellow ><strong><font size=2><div align=center>Work Habits</div></font></strong></td>
<td bgColor=yellow><strong><font size=2><div align=center>Initiative</div></font></strong></td>
</tr>
<tr>
<td><div align=center><select name="worksIndependent_#counterVariable#">
<option value="E" <cfif #cyb_works_independent# EQ "E"> selected </cfif>>Excellent</option>
<option value="G" <cfif #cyb_works_independent# EQ "G"> selected </cfif>>Good</option>
<option value="S" <cfif #cyb_works_independent# EQ "S"> selected </cfif> >Satisfactory</option>
<option value="N" <cfif #cyb_works_independent# EQ "N"> selected </cfif>>Needs Improvement</option>
</select></div>
</td>
<td><div align=center><select name="teamWork_#counterVariable#">
<option value="E" <cfif #cyb_teamwork# EQ "E"> selected </cfif>>Excellent</option>
<option value="G" <cfif #cyb_teamwork# EQ "G"> selected </cfif>>Good</option>
<option value="S" <cfif #cyb_teamwork# EQ "S"> selected </cfif> >Satisfactory</option>
<option value="N" <cfif #cyb_teamwork# EQ "N"> selected </cfif>>Needs Improvement</option>
</select></div>
</td>
<td><div align=center><select name="organization_#counterVariable#">
<option value="E" <cfif #cyb_organization# EQ "E"> selected </cfif>>Excellent</option>
<option value="G" <cfif #cyb_organization# EQ "G"> selected </cfif>>Good</option>
<option value="S" <cfif #cyb_organization# EQ "S"> selected </cfif> >Satisfactory</option>
<option value="N" <cfif #cyb_organization# EQ "N"> selected </cfif>>Needs Improvement</option>
</select></div>
</td>
<td><div align=center><select name="workHabits_#counterVariable#">
<option value="E" <cfif #cyb_work_habits# EQ "E"> selected </cfif>>Excellent</option>
<option value="G" <cfif #cyb_work_habits# EQ "G"> selected </cfif>>Good</option>
<option value="S" <cfif #cyb_work_habits# EQ "S"> selected </cfif> >Satisfactory</option>
<option value="N" <cfif #cyb_work_habits# EQ "N"> selected </cfif>>Needs Improvement</option>
</select></div>
</td>
<td><div align=center><select name="initiative_#counterVariable#">
<option value="E" <cfif #cyb_initiative# EQ "E"> selected </cfif>>Excellent</option>
<option value="G" <cfif #cyb_initiative# EQ "G"> selected </cfif>>Good</option>
<option value="S" <cfif #cyb_initiative# EQ "S"> selected </cfif> >Satisfactory</option>
<option value="N" <cfif #cyb_initiative# EQ "N"> selected </cfif>>Needs Improvement</option>
</select></div>
</td>
</tr>
<tr>
<td colspan=5 bgColor=black> </td>
</tr>
</cfoutput>
here is the code for it
<cfoutput query="getStudentData">
<cfset counterVariable = counterVariable + 1>
<cfset studentNumbers[#counterVariable#] = #cyb_student_id#>
<cfset studentComments[#counterVariable#] = #cyb_strengths#>
<tr>
<td bgColor=yellow><div align=center><strong>Student Name</strong></div></td>
<td bgColor=yellow><div align=center><strong>Midterm Mark</strong></div></td>
<td bgColor=yellow><div align=center><strong>Final Mark</strong></div></td>
<td colspan=2 bgColor=yellow><div align=center><strong>Instructors Comments</strong></div></td>
</tr>
<tr>
<input type=hidden name="studentNumber_#counterVariable#" value = #cyb_student_id#>
<input type=hidden name="courseName_#counterVariable#" value = '#cyb_course_desc#'>
<td><input type=hidden name="LastName_#counterVariable#" value="#cyb_last_name#"><input type=hidden name="FirstName_#counterVariable#" value="#cyb_first_name#"><FONT size=4 color=mediumblue>#cyb_last_name# #cyb_first_name#</font></td>
<td><div align=center><input type=text name="Midterm_#counterVariable#" value="#cyb_Midterm_mark#" size=10></div></td>
<td><div align=center><input type=text name="FinalMark_#counterVariable#" value="#cyb_final_mark#" size=10></div></td>
<td colspan = 2><div align=center><textarea name="comment_#counterVariable#" cols=20>#studentComments["#counterVariable#"]#</textarea><a href='Comments.asp?id=#cyb_student_id#&oid=#oid#&course=#course#'><img src="images/commentButton.png"></a></div></td>
</tr>
<tr>
<td bgColor=yellow><strong><font size=2><div align=center>Works<br>Independently</div></font></strong></td>
<td bgColor=yellow><strong><font size=2><div align=center>Team Work</div></font></strong></td>
<td bgColor=yellow ><strong><font size=2><div align=center>Organization</div></font></strong></td>
<td bgColor=yellow ><strong><font size=2><div align=center>Work Habits</div></font></strong></td>
<td bgColor=yellow><strong><font size=2><div align=center>Initiative</div></font></strong></td>
</tr>
<tr>
<td><div align=center><select name="worksIndependent_#counterVariable#">
<option value="E" <cfif #cyb_works_independent# EQ "E"> selected </cfif>>Excellent</option>
<option value="G" <cfif #cyb_works_independent# EQ "G"> selected </cfif>>Good</option>
<option value="S" <cfif #cyb_works_independent# EQ "S"> selected </cfif> >Satisfactory</option>
<option value="N" <cfif #cyb_works_independent# EQ "N"> selected </cfif>>Needs Improvement</option>
</select></div>
</td>
<td><div align=center><select name="teamWork_#counterVariable#">
<option value="E" <cfif #cyb_teamwork# EQ "E"> selected </cfif>>Excellent</option>
<option value="G" <cfif #cyb_teamwork# EQ "G"> selected </cfif>>Good</option>
<option value="S" <cfif #cyb_teamwork# EQ "S"> selected </cfif> >Satisfactory</option>
<option value="N" <cfif #cyb_teamwork# EQ "N"> selected </cfif>>Needs Improvement</option>
</select></div>
</td>
<td><div align=center><select name="organization_#counterVariable#">
<option value="E" <cfif #cyb_organization# EQ "E"> selected </cfif>>Excellent</option>
<option value="G" <cfif #cyb_organization# EQ "G"> selected </cfif>>Good</option>
<option value="S" <cfif #cyb_organization# EQ "S"> selected </cfif> >Satisfactory</option>
<option value="N" <cfif #cyb_organization# EQ "N"> selected </cfif>>Needs Improvement</option>
</select></div>
</td>
<td><div align=center><select name="workHabits_#counterVariable#">
<option value="E" <cfif #cyb_work_habits# EQ "E"> selected </cfif>>Excellent</option>
<option value="G" <cfif #cyb_work_habits# EQ "G"> selected </cfif>>Good</option>
<option value="S" <cfif #cyb_work_habits# EQ "S"> selected </cfif> >Satisfactory</option>
<option value="N" <cfif #cyb_work_habits# EQ "N"> selected </cfif>>Needs Improvement</option>
</select></div>
</td>
<td><div align=center><select name="initiative_#counterVariable#">
<option value="E" <cfif #cyb_initiative# EQ "E"> selected </cfif>>Excellent</option>
<option value="G" <cfif #cyb_initiative# EQ "G"> selected </cfif>>Good</option>
<option value="S" <cfif #cyb_initiative# EQ "S"> selected </cfif> >Satisfactory</option>
<option value="N" <cfif #cyb_initiative# EQ "N"> selected </cfif>>Needs Improvement</option>
</select></div>
</td>
</tr>
<tr>
<td colspan=5 bgColor=black> </td>
</tr>
</cfoutput>