关于天气的手抄报内容:数据的删除和修改功能无法进行,请求帮助

来源:百度文库 编辑:杭州交通信息网 时间:2024/05/04 07:55:26
<html>
<head>
<title>热喷涂材料信息修改</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
、<!--#include file="conn.asp"-->
<%
id1=trim(Request("id"))
set rs=server.createobject("adodb.recordset")
sql = "select * from material where id="&id1 '查询id(ID号)这条记录
rs.Open sqlcmd,conn,2,3
%>

</head>

<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" vlink="#003399" alink="#CCCCCC">
<div align="right">
</div>

<div align="center">
<table width="551" height=567 border=0 cellpadding="0" cellspacing=1>
<tbody>
<tr>
<td align=right height=18 width="92%" colspan="2" valign="middle"></td>
</tr>
<tr>
<td align=right height=43 width="92%" colspan="2">
<p align="center">
<font size="6" face="方正大标宋简体" color="#99CC00">
热喷涂材料信息修改</font></td>
</tr>
<td><table border="0" cellpadding="0" cellspacing="0">
<form action="modify.asp?id=<%=rs("id")%>" method=post name=form1>
<tr>
<td align=right height=17 width="20%"></td>
<td height=17 width="79%"> </td>
</tr>
<tr>
<td align=right height=16 width="20%"><span style="font-size: 9pt">牌号:</span></td>
<td height=16 width="79%"> <span style="font-size: 9pt"><input type="text" name="ph" size="20" class="editbox1" value="<%=rs("ph")%>"></span> </td>
</tr>
<tr>
<td align=right height=24 width="20%"><span style="font-size: 9pt">特性:</span></td>
<td height=24 width="79%"> <span style="font-size: 9pt">
<textarea name="tx" cols="57" rows="4" class="editbox2" ><% if rs("tx")<>"" then %><%=Replace(rs("tx"),"<br>",vbCrLf)%><%end if%></textarea></span> </td>
</tr>
<tr>
<td width="20%" height=11 align=right> </td>
<td height=11> </td>
</tr>
<tr>
<td width="20%" height=5 align=right></td>
<td height=5></td>
</tr>
<tr>
<td width="20%" height=43 align=right></td>
<td height=43></td>
</tr>
<tr>
<td align=right height=46 width="99%" colspan="2">
<p align="center"> <input name="cmdOK" type="button" value=修改记录>
    <input name="cmdReset" type="reset" value=重置资料> </td>
</tr>
</tbody>
</table>
<p> </div>
</form>
<%
rs.Close
set rs=nothing
set conn=nothing
%>

</body>
</html>

明天告诉你答案,我QQ114393021

select * from material where id="&id1
没有保存呀