Question

参数不足，期待是 2。

<!--#include file="conn.asp"-->

<%
oabusyname=request.cookies("oabusyname")
oabusyusername=request.cookies("oabusyusername")
oabusyuserdept=request.cookies("oabusyuserdept")
oabusyuserlevel=request.cookies("oabusyuserlevel")
if oabusyusername="" then
response.write("<script language=""javascript"">")
response.write("window.top.location.href='../default.asp';")
response.write("</script>")
response.end
end if
set rse=server.createobject("adodb.recordset")
sqle = "select * from wenzhang where id="&request.querystring("id")
rse.open sqle,conn,1
if rse("已联系")=true then
response.write("<script language=""javascript"">")
response.write("alert(""此人已联系！"");")
response.write("history.go(-1);")
response.write("</script>")
response.end
else

if (rse("电话")="") and (rse("手机")="") then
response.write("<script language=""javascript"">")
response.write("alert(""请先填上客户电话或手机！"");")
response.write("history.go(-1);")
response.write("</script>")
response.end
else
errorinfo=""
set rsd=server.createobject("adodb.recordset")
sql = "update wenzhang set "
sql = sql &"联系时间=now(),"
sql = sql & "意向说明='"&request.cookies("yixiang3")&"',"
sql = sql & "意向=true where id="&request.querystring("id")
// rsd.open sql,conn,1,1

conn.Execute sql

conn.close
set rse=nothing
set rsd=nothing
response.write("<script language=""javascript"">")
response.write("alert(""成功意向！"");")
response.write("history.go(-1);")
response.write("</script>")
response.end
end if
end if

%>
估计不是这个问题

Answer 1

conn.Execute sql 这是第40行，它没有错，错在了sql的值上了，请看sql的值，也就是下面这一段：

sql = "update wenzhang set "
sql = sql &"联系时间=now(),"
sql = sql & "意向说明='"&request.cookies("yixiang3")&"',"
sql = sql & "意向=true where id="&request.querystring("id")

你可以看到第2行中的now()是asp的语句，用来获取时间，你把它当做字符串直接放到sql里了，所以就出现了参数不足的问题。
你试着用后面添加request的方法写now()应该就对了