删除access的问题~````
example6:
<form name="form1" method="post" action="example72.asp">
delete:
<input type="text" name="id">
<input type="submit" name="Submit" value="提交">
</form>
example72:
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("example3.mdb")
exec="select * from guestbook where id="&request("id")
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
%>
<form name="form" method="post" action="example7.asp">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<%
do while not rs.eof
%><tr>
<td><%=rs("id")%></td>
<td><%=rs("name")%></td>
<td><%=rs("tel")%></td>
<td><%=rs("message")%></td>
</tr>
<tr>
<td>
<input type="submit" name="submit" value="提交">
</td>
</tr>
</form>
<%
rs.movenext
loop
%>
</table>
example7:
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("example3.mdb")
exec="delete * from guestbook where id="&request("id")
conn.execute exec
response.write "删除成功!"
%>
这个example7里面的exec="delete * from guestbook where id="&request("id")
这个="&request("id")里的id想要调用example6里的id，怎么调用？
问题点数：20、回复次数：4Top
1 楼lovexpshl（白浪）回复于 2006-03-10 12:26:44 得分 15
在example72中的
<form name="form" method="post" action="example7.asp">
改成
<form name="form" method="post" action="example7.asp?id=<%=rs("id")%>">
原理id的值由example6中的id传到example72中，再由example72传到example7中Top
2 楼Cooly（☆不做开发很久了......☆）回复于 2006-03-10 12:27:21 得分 0
-_-;;
<form name="form1" method="post" action="example7.asp">
delete:
<input type="text" name="id">
<input type="submit" name="Submit" value="提交">
</form>
example7: 这个文件名是example7.asp
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("example3.mdb")
exec="delete * from guestbook where id="&request("id")
conn.execute exec
response.write "删除成功!"
%>
Top
3 楼R_Kill（圣御飞侠）回复于 2006-03-10 12:30:29 得分 5
在example6 做个<input type="hidden" name="ver" value="<%=id%>">Top
4 楼ywuque（花无缺）回复于 2006-03-10 12:46:12 得分 0
会了，谢谢Top
