杭州交通信息网桂林市规划局副局长:请教高手一个ASP问题
来源：百度文库 编辑：杭州交通信息网 时间：2024/04/30 00:32:47
case "shenhe"
if request("shenhe").count=0 then
response.write"<script language=javascript>alert('请选择审核的评论?');history.go(-1);</script>"
response.end
end if
conn.execute "update pl set shenhe=1 where pinglunid in ("&request("shenhe")&")"
response.write"<script language=javascript>alert('审核成功?');history.go(-1);</script>"
response.end
end select
运行时提示：
错误类型：
Microsoft JET Database Engine (0x80040E10)
至少一个参数没有被指定值。
../admin/Savesellreview.asp, 第 31 行
conn.execute "update pl set shenhe=1 where pinglunid in ('"&request('shenhe')&"')"
错误类型：
Microsoft VBScript 编译器错误 (0x800A03EA)
语法错误
/ucar/admin/Savesellreview.asp, line 30, column 68
conn.execute "update pl set shenhe=1 where pinglunid in ('"&request('shenhe')&"')"
if request("shenhe").count=0 then
response.write"<script language=javascript>alert('请选择审核的评论?');history.go(-1);</script>"
response.end
end if
conn.execute "update pl set shenhe=1 where pinglunid in ("&request("shenhe")&")"
response.write"<script language=javascript>alert('审核成功?');history.go(-1);</script>"
response.end
end select
运行时提示：
错误类型：
Microsoft JET Database Engine (0x80040E10)
至少一个参数没有被指定值。
../admin/Savesellreview.asp, 第 31 行
conn.execute "update pl set shenhe=1 where pinglunid in ('"&request('shenhe')&"')"
错误类型：
Microsoft VBScript 编译器错误 (0x800A03EA)
语法错误
/ucar/admin/Savesellreview.asp, line 30, column 68
conn.execute "update pl set shenhe=1 where pinglunid in ('"&request('shenhe')&"')"
in后面必须跟一个记录集
request('shenhe')是外部集合，不搭界的
conn.execute "update pl set shenhe=1 where pinglunid in ('"&request('shenhe')&"')"
conn.execute "update [pl] set shenhe=1 where pinglunid="&request('shenhe')&""