update 语句提示未结束问题-急!!

来源：百度知道 编辑：UC知道 时间：2024/05/15 05:44:06
语句未结束
/毕业设计/changesub.asp, line 9, column 36
str="Update book set [name]='"&bname"',[author]='"&bauthor&"',[value]='"&bvalue&"',[jieshao]='"&bjianjie&"'where id="&id

老是说这句语句没结束,想不通
有没有[]都一样
id是自动编号的
<%
bname=request.form("bookname")
bauthor=request.form("bookauthor")
bvalue=request.form("bookvalue")
bjianjie=request.form("bookjianjie")
id= trim(request("bookid"))
str="update book set [name]='"&bname"',[author]='"&bauthor&"',[value]='"&bvalue&"',[jieshao]='"&bjianjie&"'where id="&id
set rs=server.CreateObject("adodb.recordset")
rs.open str,con,1,3
response.Write(str)
rs.close
set con=nothing
response.Redirect("login.asp")
%>
<%
bname=requ

把'"&bname"'弄成'"&bname&"'

<%
bname=request.form("bookname")
bauthor=request.form("bookauthor")
bvalue=request.form("bookvalue")
bjianjie=request.form("bookjianjie")
id= trim(request("bookid"))
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from [book] where id="&id,conn,1,3
rs("name")=bname
rs("author")=bauthor
rs("value")=bvalue
rs("jieshao")=bjianjie
rs.update
rs.close
set rs=nothing
response.Redirect("login.asp")
%>
用这个试一下