这个错误怎么修改啊?各位高手帮忙看下...
错误提示:
Microsoft OLE DB Provider for SQL Server 错误 '80040e37'
对象名 'Fee' 无效。
/admin/saveFee.asp,行33
相关代码:
<%
if T_FeeID<>0 then
sql= "update Fee set FeeTopic='"&T_FeeTopic&"',FeeClientID="&T_FeeClientID&",FeeTouchManID="&T_FeeTouchManID&",FeeSort='"&T_FeeSort&"',FeeDate='"&T_FeeDate&"',FeeMoney='"&T_FeeMoney&"',FeeOppID='"&T_FeeOppID&"',FeeDetail='"&T_FeeDetail&"',FeeCreatorID="&T_FeeCreatorID&",FeeCreateDate='"&T_FeeCreateDate&"',FeeOpenFlag="&OpenFlag&",FeeRevisorID="&T_FeeOperatorID&",FeeReviseDate='"&T_FeeUpdateDate&"' where FeeID= '" & T_FeeID & "'"
else
sql="insert into Fee (FeeTopic,FeeClientID,FeeTouchManID,FeeSort,FeeDate,FeeMoney,FeeOppID,FeeDetail,FeeCreatorID,FeeCreateDate,FeeOpenFlag,FeeRevisorID,FeeReviseDate) values ('"&T_FeeTopic&"',"&T_FeeClientID&","&T_FeeTouchManID&",'"&T_FeeSort&"','"&T_FeeDate&"','"&T_FeeMoney&"','"&T_FeeOppID&"','"&T_FeeDetail&"',"&T_FeeCreatorID&",'"&T_FeeCreateDate&"',"&OpenFlag&","&T_FeeOperatorID&",'"&T_FeeUpdateDate&"')"
end if
conn.execute( sql ) '执行数据库更新 (这是第三十三行代码)
if T_FeeID = 0 then
set rs=conn.execute("select top 1 FeeID from Fee where FeeCreatorID="&User_ID&" order by FeeID desc")
T_FeeID = rs("FeeID")
rs.close
end if
%>
|