我想搜数据库里的老师信息和学生信息。teacher和student分别是一张表。前面通过下拉框选择搜索教师还是学生,我用whose来获取下拉框的值
后边是搜索条件,根据科目搜索
看看帮忙我的代码:(我是新手)看看是不是语法有问题
<%
dim whose
dim kemu
dim sql
dim rs
kemu=request.form("kemu")
whose=request.form("select")
%>
<%
set rs=server.createobject("adodb.recordset")
sql="SELECT * from whose where firstjob = 'kemu' order by teacher_id desc"
rs.open sql,conn,1,1
if rs.bof or rs.eof then
rs.close
response.write "<center><font color=red>没有查询到你要的信息!"
else
do while not rs.eof
%>
<tr>
<td><div align="center"><%=rs("teacher_id")%> </div></td>
<td><div align="center"><%=rs("zhicheng")%> </div></td>
<td><div align="center"><%=left(rs("teacher_name"),1)%>老师</div></td>
<td><div align="center"><%=rs("home1")%> </div></td>
<td><div align="center"><%=rs("writer")%> </div></td>
<td><div align="center"><a href="teacher_list.asp?teacher_id=<%=rs("teacher_id")%>">查看详情</a></div></td>
<td><div align="center">
<%if rs("zt")=0 then %>
<font color="#0099CC">未认证</font>
<% else %>
<font color="#FF0000">通过认证</font>
<% end if %>
</div></td>
</tr>
<% rs.movenext
loop
rs.close
end if end if%>
參考答案:你的sql语句是不是有问题呢??
变量名应该用连接字符进行连接,否则找不到数据库
sql="SELECT * from whose where firstjob = 'kemu' order by teacher_id desc"
应该更正为
sql="select* from "&whose&" where firstjob = '"&kemu&"' order by teacher_id desc"
你先改改再看看有什么问题