求救:查询语句 急啊

Question

各位高手,请帮帮忙啊
 <form name="form1" method="post" action="student_q.asp">
      <% dim rs2,strsql2
         set rs2=server.CreateObject("adodb.recordset")
         strsql2="select xueqi from xueqi "
         rs2.open strsql2,db%> <select name="select3" size="1"  >
         <option selected> 学 期 </option>
         <%do until rs2.eof %>
         <option value="<%=rs2("xueqi")%>" <%if rs2("xueqi")= select3 then%>selected  <% end if%>><%=rs2("xueqi")%></option>
          <% 
    rs2.movenext 
             loop 
          %>
        </select> 
<%   
                 rs2.close
       set rs2=nothing
      %> </select> 
                  </div></td>
                <td width="44%"><input type="submit" name="Submit" value="确 定"></td>
              </tr>
            </table> 
              </form>
请问一下,当我要按列表框中显示出来的xueqi进行查询,那查询语句该怎么写啊
给位帮忙啊,急啊

Answer 1

sql = "select * from mytable where xueqi = '" & request(select3) & "'"