<html>
<!-- BEGIN WEBMAIL STATIONERY -->
<head></head>
<body>
<!-- WEBMAIL STATIONERY noneset -->
<DIV>Hi,</DIV>
<DIV> </DIV>
<DIV>I need to collect a list of student id numbers from one table so I can take this list, find them in another table, and display their names so their teachers can give them a score.</DIV>
<DIV> </DIV>
<DIV>I still like to use DTML but I do not know if I have the sequence-number in the proper format. This is what I have been playing with:</DIV>
<DIV> </DIV>
<DIV><dtml-call "REQUEST.set('RECORD_ID', REQUEST.SESSION['RECORD_ID'])"><BR><dtml-in lookup_students_in_course><BR> <dtml-call "REQUEST.set('student_id_temp', student_id)"><BR></dtml-in></DIV>
<DIV><dtml-in expr="_.range(sequence-number)"><BR> <dtml-call "REQUEST.set('student_id_temp', student_id_temp)"><BR><SELECT NAME="student_id_selected"><BR> <option value=""></option><BR> <dtml-in lookup_student_name sort=student_last_name><BR> <OPTION VALUE="<dtml-var student_id>"><BR> <dtml-var student_last_name>, <dtml-var student_first_name> <BR> </OPTION><BR> </dtml-in><BR></SELECT><BR></dtml-in></DIV>
<DIV> </DIV>
<DIV>I am having a hard time find reference material on this.</DIV>
<DIV> </DIV>
<DIV>Thanks,</DIV>
<DIV> </DIV>
<DIV>Larry</DIV>
<!-- END WEBMAIL STATIONERY -->
</body>
</html>