INSERTINTO语句的语法错误ASP.MicrosoftOLEDBProviderforODBCDrivers(0x80040E14)这是代码，到底是错在什么地方呢？请大虾解救！sql="insertintochanpin(xh,gg,tsxhcyl,tsxhfp,jyxhcyl,jyxhfp,tc,wfb,bd,gd,htxhcyl,pb,htxhfp,

Question

INSERT INTO 语句的语法错误ASP.Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
这是代码，到底是错在什么地方呢？请大虾解救！
sql="insert into chanpin(xh,gg,tsxhcyl,tsxhfp,jyxhcyl,jyxhfp,tc,wfb,bd,gd,htxhcyl,pb,htxhfp,hbjg,lrl,zxjg,jyxhflag,gdflag) values('"&xh&"','"&gg&"',"&tsxhcyl&","&tsxhfp&","&jyxhcyl&","&jyxhfp&","&tc&","&wfb&","&bd& ","&gd &"," &htxhcyl &"," &pb&","& htxhfp&"," & hbjg & "," & lrl &","&cbjgsum&",'"&jyxhflag&"','"&gdflag&"')"
'Response.Write( sql)
'Response.End()
Set rsst = Server.CreateObject("ADODB.Recordset")
'rsst.ActiveConnection = MM_conn_news_STRING
'rsst.Source = sql
'rsst.CursorType = 0
'rsst.CursorLocation = 2
'rsst.LockType = 1
'rsst.Open()
rsst.Open sql,connt,3

Answer 1

一定是你的字符类型不对啊..看看是不是字符型varchar的,如果是的话加上 '' 在values里面,我想应该是这个问题..