选择题型页：
<form name="form1" action="CarJishuTest.asp" method="post">
<table width="600" border="1" align="center" cellpadding="1" cellspacing="2" bordercolor="#666666">
  <tr>
    <td height="50" colspan="2"><div align="center">请选择你所要考试科目</div></td>
  </tr>
  <tr>
    <td width="155" height="50"><div align="right">请选择：</div></td>
    <td width="429" height="50"><select name="zhangjie" id="zhangjie" onchange="c(this.value);" onfocus="c(this.value);">
      <option>技术负责人</option>
      <option value="1">  模块A+模块B+模块D</option>
      <option value="2">  模块A+模块B+模块E</option>
      <option value="3">  模块A+模块B+模块F</option>
      <option value="4">  模块A+模块B+模块G</option>
      <option>质量检验员</option>
      <option value="5">  模块A+模块C+模块D</option>
      <option value="6">  模块A+模块C+模块E</option>
      <option value="7">  模块A+模块C+模块F</option>
      <option value="8">  模块A+模块C+模块G</option>
      <option value="9">机修人员:模块A+模块D</option>
      <option value="10">电器维修员:模块A+模块E</option>
      <option value="11">钣金（车身修复）人员:模块A+模块F</option>
      <option value="12">涂漆（车身涂装）人员:模块A+模块G</option>
      <option value="13">车辆技术评估（含检测）人员:模块A+模块H</option>
            </select></td>
  </tr>
  <tr>
    <td height="50" colspan="2"><div align="center">
      <input type="submit" name="Submit" value="  提   交  " />
    </div></td>
  </tr>
</table>
</form>
 
在数据库中的zhangjie字段有1-8个数字，分别代表不同的模块类型，现在在显示题库页要根据前一页要提取数据库中的题库，也就是说选择1则提取数据库里zhangjie字段下的1，2，4个选项???哎，新手中，不知道应该怎么调取，谢谢！
   <%
Randomize
intRandomNumber = Int(1000 * Rnd) + 1
if Request("zhangjie")="1" then
Sql="Select top 100 * From Papers5 where zhangjie='1' and zhangjie='2' and zhangjie='4' order BY Rnd("& (-1 * intRandomNumber) &"* id)"
else if Request("zhangjie")="2" then
Sql="Select top 100 * From Papers5 where zhangjie='1' and zhangjie='2' and zhangjie='5' order BY Rnd("& (-1 * intRandomNumber) &"* id)"
else if Request("zhangjie")="3" then
Set rs=conn.Execute(SQL)
i=0
do while not rs.eof
i=i+1
%>