在table中显示数据：编号(id)，学号...，如何得到一行数据的id值，然后把这一行删除了？
同时也有入学日期，如何得到日期，把数据进行批量删除？
nan
不是太明白问题。
SQL code:
delete from table1 where id=1
delete from table1 where date = '2009-01-01'
HTML code:
<table>
<tr>
<td>ID</td>
<td>学员姓名</td>
<td>入学日期</td>
<td>操作</td>
</tr>
<%
set rs=********
rs.open "select * from 表",conn,1,1
循环
%>
<td><%=Rs("id")&></td>
<td><%=Rs("name")&></td>
<td><%=Rs("time")&></td>
<td><a href="del.asp?id=<%=Rs("id")%>">删除</a></td>
</table>
<%
sql = "SELECT * from [table_name]"
rs.open sql, conn, 1, 1
sql = "DELETE from [table_name] where id=" & rs("id")
conn.execute("sql")
%>
VBScript code:
rs.open "select * from table",conn,1,3
whil
