网页能正常显示,但点提交后,出现错误提示
提示这一行有错误:
SQL="Select * From shenqing where id="&request("id")
语法错误 (操作符丢失) 在查询表达式 'id=' 中。
原代码:
<!--#include file="conn.asp"-->
<head>
<meta http-equiv="Content-Language" content="zh-cn">
</head>
<% dim SQL
sub navigation()
response.write " >> "
response.write "<a href='news.asp'>电子信箱</a>"
response.write " >> "
response.write "信件详情"
end sub
%>
<div align="center">
<table border="1" width="1000" id="table2" cellspacing="0" cellpadding="0" bordercolor="#C0C0C0">
<%
set rs=server.createobject("adodb.recordset")
SQL="Select * From shenqing where id="&request("id")
rs.Open SQL,conn,1,1
if rs.bof and rs.eof then
response.Redirect("def.asp")
end if
%>
<tr>
<td width="78" valign="top">
邮件主题</td>
<td>
<p align="center"> <%=rs("zhuti")%></td>
</tr>
<tr>
<td width="78" valign="top">邮件内容</td>
<td> <%=rs("neirong")%></td>
</tr>
<tr>
<td width="78" valign="top">
发 件 人</td>
<td>
<p align="right"><%=rs("xingming")%> </td>
</tr>
<tr>
<td width="78" valign="top">
联系方式</td>
<td>
<p align="right"><%=rs("lianxi")%> </td>
</tr>
<tr>
<td width="78" valign="top">
发件日期</td>
<td>
<p align="right"> <%=rs("rq")%></td>
</tr>
<tr>
<td width="78"> </td>
<td> </td>
</tr>
<tr>
<td width="78"> </td>
<td> </td>
</tr>
</table>
<p> </p>
</div>
<form method="POST" action="addit3.asp" name="form1" >
<div align="center">
<table border="0" width="700" id="table1" cellpadding="0" style="border-collapse: collapse">
<tr>
<td>
<p> </p>
<p>办理情况:</p>
<p align="center"><textarea rows="4" name="S1" cols="71" ><%=rs("banli")%></textarea></p>
<p align="left"> </p>
<p>备 注:</p>
<p align="center"><textarea rows="4" name="S2" cols="71" ><%=rs("bz")%></textarea></p>
<p align="center"><span>
<p>流水号:<input type="text" name="T1" size="10" value=<%=rs("id")%> readonly="true" type=hidden> </p></p>
<p align="left"> </p>
</td>
</tr>
<tr>
<td><p align="center"><input type="submit" value=" 提 交 " name="B1" > <input type="reset" value=" 重 置 " name="B2"></p></td>
</tr>
</table>
</div>
</form>
提示这一行有错误:
SQL="Select * From shenqing where id="&request("id")
语法错误 (操作符丢失) 在查询表达式 'id=' 中。
原代码:
<!--#include file="conn.asp"-->
<head>
<meta http-equiv="Content-Language" content="zh-cn">
</head>
<% dim SQL
sub navigation()
response.write " >> "
response.write "<a href='news.asp'>电子信箱</a>"
response.write " >> "
response.write "信件详情"
end sub
%>
<div align="center">
<table border="1" width="1000" id="table2" cellspacing="0" cellpadding="0" bordercolor="#C0C0C0">
<%
set rs=server.createobject("adodb.recordset")
SQL="Select * From shenqing where id="&request("id")
rs.Open SQL,conn,1,1
if rs.bof and rs.eof then
response.Redirect("def.asp")
end if
%>
<tr>
<td width="78" valign="top">
邮件主题</td>
<td>
<p align="center"> <%=rs("zhuti")%></td>
</tr>
<tr>
<td width="78" valign="top">邮件内容</td>
<td> <%=rs("neirong")%></td>
</tr>
<tr>
<td width="78" valign="top">
发 件 人</td>
<td>
<p align="right"><%=rs("xingming")%> </td>
</tr>
<tr>
<td width="78" valign="top">
联系方式</td>
<td>
<p align="right"><%=rs("lianxi")%> </td>
</tr>
<tr>
<td width="78" valign="top">
发件日期</td>
<td>
<p align="right"> <%=rs("rq")%></td>
</tr>
<tr>
<td width="78"> </td>
<td> </td>
</tr>
<tr>
<td width="78"> </td>
<td> </td>
</tr>
</table>
<p> </p>
</div>
<form method="POST" action="addit3.asp" name="form1" >
<div align="center">
<table border="0" width="700" id="table1" cellpadding="0" style="border-collapse: collapse">
<tr>
<td>
<p> </p>
<p>办理情况:</p>
<p align="center"><textarea rows="4" name="S1" cols="71" ><%=rs("banli")%></textarea></p>
<p align="left"> </p>
<p>备 注:</p>
<p align="center"><textarea rows="4" name="S2" cols="71" ><%=rs("bz")%></textarea></p>
<p align="center"><span>
<p>流水号:<input type="text" name="T1" size="10" value=<%=rs("id")%> readonly="true" type=hidden> </p></p>
<p align="left"> </p>
</td>
</tr>
<tr>
<td><p align="center"><input type="submit" value=" 提 交 " name="B1" > <input type="reset" value=" 重 置 " name="B2"></p></td>
</tr>
</table>
</div>
</form>