Microsoft VBScript 编译器错误 '800a0401'

来源:百度知道 编辑:UC知道 时间:2024/06/19 15:10:53
Microsoft VBScript 编译器错误 '800a0401'

语句未结束

\wwwroot\xgjb1.asp, line 24

文本为

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
set conn=server.createobject("adodb.connection")
conn.open "provider=microsoft.jet.oledb.4.0;data source="& server.mappath("db1.mdb")
Dim xyxm,xyxb,csny,xymz,xyhj,rxhj,byyx,rxsj,zymc,xyxl,bysj,xybh,sfzh
xyxm=Trim(Request.Form("xyxm"))
xyxb=Trim(Request.Form("xyxb"))
csny=Trim(Request.Form("csny"))
xymz=Trim(Request.Form("xymz"))
xyhj=Trim(Request.Form("xyhj"))
rxhj=Trim(Request.Form("rxhj"))
byyx=Trim(Request.Form("byyx"))
rxsj=Trim(Request.Form("rxsj"))
zymc=Trim(Request.Form("zymc"))
xyxl=Trim(Request.Form("xyxl"))
bysj=Trim(Request.Form("bysj"))
xybh=Trim(Reques

最后一点出错了
sql=" UPDATE jiben set 性别='"&xyxb &"',出生年月='"&csny &"',民族='"&xymz &"',户籍='"&xyhj &"',学员编号='"&xybh &"',毕业学院='"&byyx &"',身份证号='"&sfzh &"',资费='"&zczc &"',备注='"&bzbz &"' where 姓名='"&xyxm&"'"
最后WHERE的后面少加2个&连结号