主题:  帮忙看一下删除记录

我是小呆瓜

职务:普通成员
等级:3
金币:1.0
发贴:716
注册:2001/12/11 13:23:44
#12002/6/18 17:49:44
<%@LANGUAGE="VBSCRIPT"%>

<%

if(Requst.QueryString("DeletedID") <> "") then commnewdel__iid = Requst.QueryString("DeletedID")

%>
<%
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_cxsoft_STRING
Recordset1.Source = "SELECT * FROM new"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
set rsdel = Server.CreateObject("ADODB.Recordset")
rsdel.ActiveConnection = MM_cxsoft_STRING
rsdel.Source = "SELECT newboject, new, time FROM new"
rsdel.CursorType = 0
rsdel.CursorLocation = 2
rsdel.LockType = 3
rsdel.Open()
rsdel_numRows = 0
%>
<%

set commnewdel = Server.CreateObject("ADODB.Command")
commnewdel.ActiveConnection = MM_cxsoft_STRING
commnewdel.CommandText = "DELETE FROM new WHERE id=iid "
commnewdel.CommandType = 1
commnewdel.CommandTimeout = 0
commnewdel.Prepared = true
commnewdel.Execute()
Response.Redirect("denglu.asp?id=" & Request.Querystring("id"))
%>


Untitled Document























 
新闻标题:
">
时间:
">
新闻内容:







<%
Recordset1.Close()
%>
<%
rsdel.Close()
%>

错误为:Microsoft VBScript 运行时错误 错误 '800a01a8'
缺少对象: 'Requst'
/new/del.asp, 行5




7877767

职务:普通成员
等级:2
金币:1.0
发贴:528
注册:2002/2/19 0:11:31
#22002/6/19 8:17:18
你的iid的值从哪个输入框取得的?



I''MAD

职务:普通成员
等级:8
金币:11.0
发贴:9502
注册:2001/9/16 20:00:53
#32002/6/19 8:47:56
set commnewdel = Server.CreateObject("ADODB.Command")
commnewdel.ActiveConnection = MM_cxsoft_STRING
commnewdel.CommandText = "DELETE FROM new [b]WHERE id=iid[b] "
commnewdel.CommandType = 1
commnewdel.CommandTimeout = 0
commnewdel.Prepared = true
commnewdel.Execute()
Response.Redirect("denglu.asp?id=" & Request.Querystring("id"))

第一个没有赋值(iid)