ASP中request.QueryString问题
来源:百度知道 编辑:UC知道 时间:2024/05/22 19:16:04
<!--#include file="conn.asp"-->
<%
list="delete * from A_Work where Wid="&request.QueryString("Wid")
set rs=server.CreateObject("ADODB.RecordSet")
rs.open list,cn,1,1
set rs=nothing
response.write "<script language='javascript'>" & chr(13)
response.write "alert('成功删除!');" & Chr(13)
response.write "window.document.location.href='admin_info.asp';"&Chr(13)
response.write "</script>" & Chr(13)
response.End()
%>
请高手帮我看看连接字符串又错在那里了
请详细说明! 谢谢
wid是长整型的变量
不是字串
运行后的反馈信息是
技术信息(用于支持人员)
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC 驱动程序不支持所需的属性。
/2006admin/delete.asp, 第 7 行
浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
网页:
GET /2006admin/delete.asp
<%
list="delete * from A_Work where Wid="&request.QueryString("Wid")
set rs=server.CreateObject("ADODB.RecordSet")
rs.open list,cn,1,1
set rs=nothing
response.write "<script language='javascript'>" & chr(13)
response.write "alert('成功删除!');" & Chr(13)
response.write "window.document.location.href='admin_info.asp';"&Chr(13)
response.write "</script>" & Chr(13)
response.End()
%>
请高手帮我看看连接字符串又错在那里了
请详细说明! 谢谢
wid是长整型的变量
不是字串
运行后的反馈信息是
技术信息(用于支持人员)
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC 驱动程序不支持所需的属性。
/2006admin/delete.asp, 第 7 行
浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
网页:
GET /2006admin/delete.asp
conn.Execute("Delete From A_Work Where wId="&request.QueryString("Wid") &")"
请确定是数字
request.QueryString("Wid")
如果是字符串请写成
conn.Execute("Delete From A_Work Where wId='"&request.QueryString("Wid") &"')"
如果是ID集合 如 345,4565,212,321
conn.Execute("Delete From A_Work Where wId IN ("&request.QueryString("Wid") &")"
删除数据,又不返回值,干嘛要用记录集对像
DELETE 后面没有 * ...
list="DELETE FROM A_Work WHERE Wid="&request.QueryString("Wid")
需要确认 Wid 确实是数字 ...
是字符串要加单引号 ...
list="delete * from A_Work where Wid="&request.QueryString("Wid")
set rs=server.CreateObject("ADODB.RecordSet")
rs.open list,cn,1,1
set rs=nothing
改为:
cn.execute "delete * from a_work where Wid="&cint(request("Wid"))
list="delete * from