Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]第 9 行: 's' 附近有语法错误。
/paper/paper_submit/subinsert2.asp,行 35
subinsert2.asp 代码如下:
<%
dim tr,strTeacherName,strTeacherDivision,strKeyWords,strPrintYear,strPageNumber,strChinaAbstract,strEnglishAbstract,strfenlei
strTeacherName=request.Form("txtTeacherName")
strTeacherDivision=request.Form("txtTeacherDivision")
strKeyWordsCN=request.Form("txtKeyWordsCN")
strKeyWordsEN=request.Form("txtKeyWordsEN")
strPrintYear=request.Form("txtPrintYear")
strPageNumber=request.Form("txtPageNumber")
strChinaAbstract=request.Form("txtChinaAbstract")
strEnglishAbstract=request.Form("txtEnglishAbstract")
strfenlei=request.form("txtFenLei")
set conn=server.CreateObject("ADODB.Connection")
conn.open"Driver={SQL Server};Server=TSGWEB;Database=paperdata;Uid=sa;Pwd=123"
set rs=server.createobject("ADODB.recordset")
sql="update xwlwtj set Teachername1='"&strTeacherName&"', Danwei1='"&strTeacherDivision&"', KeywordCN ='"&strKeyWordsCN&"',KeywordEN ='"&strKeyWordsEN&"',ClassifyNo='"&strfenlei&"',Datetime='"&strPrintYear&"',Pagenum='"&strPageNumber&"', AbstructCH='"&strChinaAbstract&"', AbstructEN='"&strEnglishAbstract&"',paperState=3 where UserID='"&session("userid")&"'"
conn.Execute(sql) '行35
set rs=nothing
conn.close
set conn=nothing
%>