帮我找错误,ASP代码,谢谢
来源:百度知道 编辑:UC知道 时间:2024/05/01 11:10:21
<!--#include file="conn.asp"-->
<%
if request.QueryString("no")="eshop" then
id=request("id")
title=request("title")
content=request("content")
If title="" Then
response.write "SORRY <br>"
response.write "请输入更新内容的标题!!<a href=""javascript:history.go(-1)"">返回重输</a>"
response.end
end if
If content="" Then
response.write "SORRY <br>"
response.write "内容不能为空!!<a href=""javascript:history.go(-1)"">返回重输</a>"
response.end
end if
set rs=server.CreateObject("adodb.recordset")
sql="select * from news where id="&id
rs.open sql,conn,1,3
rs("title")=title
rs("newclass")=newclass
rs("content")=content
rs("time")=now
<%
if request.QueryString("no")="eshop" then
id=request("id")
title=request("title")
content=request("content")
If title="" Then
response.write "SORRY <br>"
response.write "请输入更新内容的标题!!<a href=""javascript:history.go(-1)"">返回重输</a>"
response.end
end if
If content="" Then
response.write "SORRY <br>"
response.write "内容不能为空!!<a href=""javascript:history.go(-1)"">返回重输</a>"
response.end
end if
set rs=server.CreateObject("adodb.recordset")
sql="select * from news where id="&id
rs.open sql,conn,1,3
rs("title")=title
rs("newclass")=newclass
rs("content")=content
rs("time")=now
rs.open ,conn,3,3
这是个什么东西
这样
sqlstr = "select * from news where id='"&id&"'"
rs.open sqlstr,conn,3,3
写程序要规范
sqlstr = "select * from news where id='id'"
TO:wu_wang
rs.open "select * from news where id="&id,conn,3,3
这行这样写OK的!~~~~~~~~~~~~
对呀,那样写是正确的
但是为何出现那种种错呢