注册 登录
编程论坛 ASP技术论坛

大家,帮忙看一下,明天早上要答辩了!!!

niuqinrong 发布于 2008-05-09 19:22, 776 次点击
<!--#include file="conn.asp"-->
<%
dim id
id=trim(request("id"))
%>

<%
   update admin_xx set sfd=1 where id="id"     这个语句有错误,帮忙看一下!!!

%>
<%
              set rs=server.createobject("adodb.recordset")
               sql="select * from admin_xx where id="&id
                rs.open sql,conn,1,1
                 %>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>邮件详细信息</title>
<link rel="stylesheet" href="style.css">
</head>

<body>
<!--#include file="u_top.asp"-->
<table width="80%" border="1" align="center">
  <tr>
    <td align="center" width="40%">发件人:</td>
    <td align="center"><%=rs("fjr")%></td>
  </tr>
  <tr>
    <td align="center" width="40%">日期:</td>
    <td align="center"><%=rs("date")%></td>
  </tr>
  <tr>
    <td align="center" width="40%">标题</td>
    <td align="center"><%=rs("bt")%></td>
  </tr>
  <tr>
    <td colspan="2"><%=rs("nr")%></td>
  </tr>
  <tr>
    <td align="center" colspan="2">回复&nbsp;&nbsp;删除</td>
  </tr>
</table>

</body>
</html>
3 回复
#2
hxfly2008-05-09 19:54
"update admin_xx set sfd=1 where id="&id
#3
hxfly2008-05-09 19:55
你这句话都没执行,写它有什么用?
#4
feelingxj2008-05-10 00:45
update admin_xx set sfd=1 where id="id"作为一个SQL语句,如果写要按字符串来写,然后交由程序执行.
比如SQL = "update admin_xx set sfd=1 where id="id""
1