Question

语法错误 (操作符丢失) 在查询表达式 'id=' 中

Microsoft JET Database Engine '80040e14'

语法错误 (操作符丢失) 在查询表达式 'id=' 中。

\wwwroot\admin\news\addnews.asp, line 21

bigclassid=request("big")
smallclassid=request("small")

set brs=conn.execute("select bigclassname from bigclass where id="&BIGCLASSID)
bigclassname=brs("bigclassname")
brs.close
set brs=nothing

set srs=conn.execute("select * from smallclass where id="&smallclassid)
smallclassname=srs("smallclassname")
srs.close
set srs=nothin

content=request("content")
if content <> "" then
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from news",conn,1,3
rs.addnew
rs("bigclassname")=bigclassname
rs("smallclassname")=smallclassname
rs("bigclassid")=bigclassid
rs("smallclassid")=smallclassid
rs("newsname")=trim(request("newsname"))
rs("addname")=trim(request("addname"))
rs("zuozhe")=trim(request("zuozhe"))
rs("newscontent")=content
rs("image")=trim(request("image"))
rs("image2")=trim(request("image2"))
rs("imgname1")=trim(request("imgname1"))
rs("imgname2")=trim(request("imgname2"))
rs("addtime")=now()
rs("viewcount")=0
rs.update
rs.close
set rs=nothing
response.write "<script language=javascript>alert('添加成功！');window.location.href='editnews.asp';</script>"

else
response.Write "<script language=javascript>alert('请输入新闻内容');window.history.back(-1);</script>"
end if
end if
第21行
set srs=conn.execute("select * from smallclass where id="&smallclassid)

Answer 1

第21行 改成
set srs=conn.execute("select * from smallclass where id="&smallclassid&"")
或者
str="select * from smallclass where id="&smallclassid;
set srs=conn.execute(str);