问一下这个哪里错了？

[roam831]

Microsoft VBScript 编译器错误 错误 '800a03f6'

缺少 'End'

/iisHelp/common/500-100.asp，行242

Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e10'

[Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 1。

/cnc/savekhxx.asp，行19

[roam831]

代码如下，19是conn那行，我的目地是在添加到这个的同时，把同添加到这个表相同的jsh从另一表删除，刚开始是可以成功，后来就不行了.
<!--#include file="conn.asp"-->
<%if session("admin")="" then
response.Write "<script LANGUAGE='javascript'>alert('网络超时或者您还没有登录请登录');history.go(-1);</script>"
response.End
else
if session("flag")>1 then
response.Write "<div align=center><font size=80 color=red><b>您没有此项目管理权限！</b></font></div>"
response.End
end if
end if
function HTMLEncode2(fString)
fString = Replace(fString, CHR(13), "")
fString = Replace(fString, CHR(10) & CHR(10), "</P><P>")
fString = Replace(fString, CHR(10), "<BR>")
HTMLEncode2 = fString
end function
dim jsh
jsh=request("jsh")
conn.execute"delete from product where jsh like "&jsh&""

set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from user",conn,1,3
rs.AddNew
rs("cppp")=trim(request("cppp"))
rs("cpxh")=trim(request("cpxh"))
rs("jsh")=trim(request("jsh"))
rs("ickh")=trim(request("ickh"))
rs("azsj")=trim(request("azsj"))
rs("fwh")=trim(request("fwh"))
rs("khxm")=trim(request("khxm"))
rs("khdz")=trim(request("khdz"))
rs("khdh")=trim(request("khdh"))
rs("khsj")=trim(request("khsj"))
rs("sfzh")=trim(request("sfzh"))
rs("skpd")=trim(request("skpd"))
rs("sfkp")=trim(request("sfkp"))
rs("azwz")=trim(request("azwz"))
rs("azry")=trim(request("azry"))
rs("sfqk")=trim(request("sfqk"))
rs("zlbz")=htmlencode2(trim(request("zlbz"))) '备注说明
rs.Update
rs.Close
set rs=nothing
response.Write "<script language=javascript>alert('添加成功！');history.go(-1);</script>"
response.End
%>

[tiandiqing]

你的conn呢？

[DeltaCat]

conn.execute"delete from product where jsh like '" & jsh & "'"

或者
conn.execute"delete from product where jsh like '%" & jsh & "%'"

[eduxh]

请问是什么数据库？要实现怎么样的功能？jsh是什么类型的？
conn.execute"delete from product where jsh like "&jsh&"" 语法肯定错误
改：conn.execute "delete from product where jsh="& jsh &"
或：conn.execute "delete from product where jsh='"& jsh &"'"
又或：conn.execute "delete from product where jsh like '%"& jsh &"%'"
等！

[roam831]

是ACCESS数据库
jsh文本类型，所以应该不能用=啊
只能用like，而且要全部匹配才对啊

[liaoxing]

同意

[roam831]

我SB了，我少了''这个了
就是like后面匹配的
谢谢各位了
马上结贴