- 论坛徽章:
- 0
|
出现错误处的全部代码如下(提示出错的那句是Rs.Update):
-----------------------------------------------
Sql = "SELECT WoWo_Source.*, WoWo_User.User_CoolName, WoWo_User.User_Address, WoWo_SrcType.Type_name, WoWo_SrcChild.Child_name " & _
"FROM WoWo_SrcChild INNER JOIN (WoWo_SrcType INNER JOIN (WoWo_Source INNER JOIN WoWo_User ON WoWo_Source.Src_UserID = WoWo_User.User_ID) ON WoWo_SrcType.Type_id = WoWo_Source.Src_TypeID) ON WoWo_SrcChild.Child_id = WoWo_Source.Src_ChildID " & _
"WHERE WoWo_Source.Src_ID="&Src_ID
if Session("_WUserID")<>ssrc_userid then
sql = sql &" and WoWo_Source.Src_IsOver=0"
end if
Rs.open Sql,conn,1,2
if rs.eof then
Call Wodig.MsgBox2("无法找到资源!",0,"0")
Response.End()
else
Rs("Src_SeeNum") = Rs("Src_SeeNum") + 1
Rs.Update
Src_Type = Rs("Src_TypeID") '类型
Src_Child = Rs("Src_ChildID") '二级类别
Src_SeeNum = Rs("Src_SeeNum")
end if
---------------------------------------------
我该如何改?
问题补充:提示的错误是:
Microsoft OLE DB Provider for ODBC Drivers 错误 '8000ffff'
不能更新查询,因为 FROM 子句不是单一的简单表名。
/SrcShow.asp,行 83 |
|