28,407
社区成员
发帖
与我相关
我的任务
分享帮我一下`~~
<!--#include file="inc/conn_ly.asp"-->
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<link rel="stylesheet" type="text/css" href="Admin_Style.css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
</HEAD>
<BODY>
<%
dim lyid
lyid=request.QueryString("id")%>
<%
dim rs2
if request.QueryString("action")="save" then
set rs2=server.CreateObject("adodb.recordset")
rs2.open "select * from ly where id="&lyid,conn,1,3
rs2("huifu")=trim(request("huifu"))
rs2("backdate")=now
rs2.update
rs2.close
set rs=nothing
session("fkfk")=minute(now)
response.write "<script language=javascript>alert('更改成功！');history.go(-1);</script>"
response.End
end if
%>
<table width="500" border="0" align="center" height="131" bordercolor="#eeeeee" bgcolor="#eeeeee">
<form name="form1" method="post" action="lyedit.asp?action=save">
<tr>
<td height="17" width="100"> </td>
<td height="17" width="384">回复留言信息：</td>
</tr>
<tr>
<td height="102" width="100"></td>
<td height="102" width="384">
<textarea name="huifu" value="&trim(rs("huifu"))&" id="huifu" cols="30" rows="10"></textarea>
<p>
<input type="submit" name="Submit3" value="提交信息" onClick="return checkfk();">
</p>
</td>
</tr>
</form>
</table>
</BODY>
</HTML>
<SCRIPT LANGUAGE="JavaScript">
<!--
function checkspace(checkstr) {
var str = '';
for(i = 0; i < checkstr.length; i++) {
str = str + ' ';
}
return (str == checkstr);
}
function checkfk()
{
if(checkspace(document.form1.huifu.value)) {
document.form1.huifu.focus();
alert("您没有填写主题！");
return false;
}
//-->
</script>
这是个留言板的回复~~~试了n次~~都不清楚什么地方出了错~~~
提示是“语法错误（操作符丢失）在查询表达式‘id=’”中
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<link rel="stylesheet" type="text/css" href="Admin_Style.css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
</HEAD>
<BODY>
<%
dim lyid
lyid=request.QueryString("id")%>
<%
dim rs2
if request.QueryString("action")="save" then
set rs2=server.CreateObject("adodb.recordset")
rs2.open "select * from ly where id="&lyid,conn,1,3
rs2("huifu")=trim(request("huifu"))
rs2("backdate")=now
rs2.update
rs2.close
set rs=nothing
session("fkfk")=minute(now)
response.write "<script language=javascript>alert('更改成功！');history.go(-1);</script>"
response.End
end if
%>
<table width="500" border="0" align="center" height="131" bordercolor="#eeeeee" bgcolor="#eeeeee">
<form name="form1" method="post" action="lyedit.asp?action=save">
<tr>
<td height="17" width="100"> </td>
<td height="17" width="384">回复留言信息：</td>
</tr>
<tr>
<td height="102" width="100"></td>
<td height="102" width="384">
<textarea name="huifu" value="&trim(rs("huifu"))&" id="huifu" cols="30" rows="10"></textarea>
<p>
<input type="submit" name="Submit3" value="提交信息" onClick="return checkfk();">
</p>
</td>
</tr>
</form>
</table>
</BODY>
</HTML>
<SCRIPT LANGUAGE="JavaScript">
<!--
function checkspace(checkstr) {
var str = '';
for(i = 0; i < checkstr.length; i++) {
str = str + ' ';
}
return (str == checkstr);
}
function checkfk()
{
if(checkspace(document.form1.huifu.value)) {
document.form1.huifu.focus();
alert("您没有填写主题！");
return false;
}
//-->
</script>
这是个留言板的回复~~~试了n次~~都不清楚什么地方出了错~~~
提示是“语法错误（操作符丢失）在查询表达式‘id=’”中
...全文
请发表友善的回复…
发表回复
潜水的鱼 2004-01-03
- 打赏
- 举报
调试ID有没值传过来,输出ID就知道了
response.write request.QueryString("id")
response.write request.QueryString("id")
lgdncy 2004-01-03
- 打赏
- 举报
用调试语句调试，要学会怎样调试一个程序，哈哈~~~~~~~~~~~
starboy1413 2004-01-03
- 打赏
- 举报
一定ID没有传过来
lyid=request("id")
sql="select * from ly where id="&lyid
rs2.open sql,conn,1,3
<input type=hidden value=<%=rs("id")%> name=id>:把这句加到form里
lyid=request("id")
sql="select * from ly where id="&lyid
rs2.open sql,conn,1,3
<input type=hidden value=<%=rs("id")%> name=id>:把这句加到form里
月小升java-er点com 2004-01-03
- 打赏
- 举报
sql="select * from ly where id="&lyid
rs2.open sql,conn,1,3
rs2.open sql,conn,1,3
xianglong 2004-01-03
- 打赏
- 举报
查查ID传来啥值~
