ASP为什么删除记录不行的,??请教ASP高手~~~~~~

sql="select * from student where s_id="&s_id

你把sql="select * from student where s_id=cint('"&s_id&"')"
改成sql="delete * from student where s_id=cint('"&s_id&"')"

<%
if session("username")="" then
response.redirect "admin.asp"
end if
s_id=request("s_id")
sql="select * from student where s_id=cint('"&s_id&"')"
set rs=server.createobject("adodb.recordset")
rs.Open sql,conn,3,2
if not rs.eof then
rs.delete
rs.update
response.redirect "admin.asp"
end if
%>