ASP留言版获取不到信息

来源:百度知道 编辑:UC知道 时间:2024/09/22 01:18:55
if not request.querystring("id")=""then
strdeletesql="delete from message where id=" & request.querystring("id")
set rsdelete=server.createobject("adodb.recordset")
rsdelete.open strdeletesql,conn,1,3
set rsdelete=nothing
response.redirect"readmessage.asp"
end if

帮我看看是哪地方的问题

if not request.querystring("id")=""then
strdeletesql="select * from message where id=" & request.querystring("id") '注意这裏
set rsdelete=server.createobject("adodb.recordset")
rsdelete.open strdeletesql,conn,1,3
rsdelete.delete '注意这裏
rsdelete.update '注意这裏
rsdelete.close
set rsdelete=nothing
rsdelete.conn
set rsdelete=nothing
response.redirect"readmessage.asp"
end if

数据库连接有没有错误?

代码没有错误

尝试 ‘"& request.querystring("id")&“’”

if not request.querystring("id")=""then
strdeletesql="delete from message where id=" & request.querystring("id")
conn.execute (strdeletesql)
response.redirect"readmessage.asp"
end if