[Microsoft][ODBC SQL Server Driver][SQL Server]第 1 行: ',' 附近有语法错误。

[chunchun_11]

急！！！高手帮我解决一下错误！

TESTID=request.form("TESTID")
CONTROLID=request.form("CONTROLID")
CMK=request.form("CMK")
ISCII=request.form("ISCII")
VIDEONETID=request.form("VIDEONETID")
TESTDATE=request.form("TESTDATE")
PGFY=request.form("PGFY")
COMPETITIVE=request.form("COMPETITIVE")
SELECTORHALOPRODUCTID=request.form("SELECTORHALOPRODUCTID")
PPSHALOPRODUCTID=request.form("PPSHALOPRODUCTID")
AGENCYID=request.form("AGENCYID")
SUPPLIER=request.form("SUPPLIER")
TARGET=request.form("TARGET")
CAMPAIGNID=request.form("CAMPAIGNID")
COUNTRYORIGINID=request.form("COUNTRYORIGINID")
COUNTRYTESTEDID=request.form("COUNTRYTESTEDID")
STIMULUSTITLE=request.form("STIMULUSTITLE")
TESTLANGUAGEID=request.form("TESTLANGUAGEID")
AIRED=request.form("AIRED")
ADHIS=request.form("ADHIS")
PGGBUID=request.form("PGGBUID")
ASISPECGBUID=request.form("ASISPECGBUID")
RECRUITMENT=request.form("RECRUITMENT")
INTLOCATION=request.form("INTLOCATION")
MAGPRO=request.form("MAGPRO")
ROUGH=request.form("ROUGH")
STIMULUSFORMATID=request.form("STIMULUSFORMATID")
STIMULUSLLENGTH=request.form("STIMULUSLLENGTH")
SIZE1=request.form("SIZE")
N_TIER1=request.form("N_TIER1")
N_TIER2=request.form("N_TIER2")
N_TIER3=request.form("N_TIER3")
N_TIER4=request.form("N_TIER4")
INTMETHOD=request.form("N_TIER4")
TESTMETHOD=request.form("TESTMETHOD")
COPYTYPEID=request.form("COPYTYPEID")
NEW1=request.form("NEW")
AD_CHAR1=request.form("AD_CHAR1")
AD_CHAR2=request.form("AD_CHAR2")
AD_CHAR3=request.form("AD_CHAR3")
AD_CHAR4=request.form("AD_CHAR4")
VALIDATION=request.form("VALIDATION")
AD_FORM=request.form("AD_FORM")
DRTVCODE=request.form("DRTVCODE")
'response.Write DRTVCODE
'response.end

RESERACHCOST=request.form("RESERACHCOST")

Comment=request.form("Comment")
exec="insert into tblTest(TESTID,CONTROLID,CMK,ISCII,VIDEONETID,TESTDATE,PGFY,COMPETITIVE,SELECTORHALOPRODUCTID,PPSHALOPRODUCTID,AGENCYID,SUPPLIER,TARGET,CAMPAIGNID,COUNTRYORIGINID,COUNTRYTESTEDID,STIMULUSTITLE,TESTLANGUAGEID,AIRED,ADHIS,PGGBUID,ASISPECGBUID,RECRUITMENT,INTLOCATION,MAGPRO,ROUGH,STIMULUSFORMATID,STIMULUSLLENGTH,SIZE,N_TIER1,N_TIER2,N_TIER3,N_TIER4,TESTMETHOD,COPYTYPEID,NEW,AD_CHAR1,AD_CHAR2,AD_CHAR3,AD_CHAR4,VALIDATION,AD_FORM,DRTVCODE,MONEYSPENDING,RESERACHCOST,MEDIASPENDING,Comment) values('"+TESTID+"','"+CONTROLID+"','"+CMK+"','"+ISCII+"','"+VIDEONETID+"','"+TESTDATE+"','"+PGFY+"','"+COMPETITIVE+"','"+SELECTORHALOPRODUCTID+"','"+PPSHALOPRODUCTID+"','"+AGENCYID+"','"+SUPPLIER+"','"+TARGET+"','"+CAMPAIGNID+"','"+COUNTRYORIGINID+"','"+COUNTRYTESTEDID+"','"+STIMULUSTITLE+"','"+TESTLANGUAGEID+"','"+AIRED+"','"+ADHIS+"','"+PGGBUID+"','"+ASISPECGBUID+"','"+RECRUITMENT+"','"+INTLOCATION+"','"+MAGPRO+"','"+ROUGH+"','"+STIMULUSFORMATID+"','"+STIMULUSLLENGTH+"','"+SIZE1+"','"+N_TIER1+"','"+N_TIER2+"','"+N_TIER3+"','"+N_TIER4+"','"+TESTMETHOD+"','"+COPYTYPEID+"','"+NEW1+"','"+AD_CHAR1+"','"+AD_CHAR2+"','"+AD_CHAR3+"','"+AD_CHAR4+"','"+VALIDATION+"','"+AD_FORM+"','"+DRTVCODE+"','"+RESERACHCOST+"','"+Comment+"')"

[cpp2017]

把sql打出来,放在查询分析器中运行一下.

[yalan]

看见就头晕~~~能把具体出错的那一行表示出来吗？大家都容易看些好帮你

[leohuang]

size改为[size]
另外values少了两个字段的值,你再检查一下

[chunchun_11]

PRODUCTID=request.form("PRODUCTID2")
PRODUCTLEVELID=request.form("PRODUCTLEVELID2")
PURCH_Q_TYPE=request.form("PURCH_Q_TYPE")
PURCH_INT_SCALE=request.form("PURCH_INT_SCALE")
FRQ_Q_TYPE=request.form("FRQ_Q_TYPE")
FRQ_SCALE=request.form("FRQ_SCALE")
sql1="insert into tblDiagPI_Q(PRODUCTID,PRODUCTLEVELID,PURCH_Q_TYPE,PURCH_INT_SCALE,FRQ_Q_TYPE,FRQ_SCALE) values('"+PRODUCTID+"','"+PRODUCTLEVELID+"','"+PURCH_Q_TYPE+"','"+PURCH_INT_SCALE+"','"+FRQ_Q_TYPE+"','"+FRQ_SCALE+"')"
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e07'

[Microsoft][ODBC SQL Server Driver][SQL Server]将数据类型 varchar 转换为 时出错。 行 80
80行就是sql2，PRODUCTLEVELID,PURCH_Q_TYPE,PURCH_INT_SCALE,FRQ_Q_TYPE,FRQ_SCALE数据类型是numeric。

[chunchun_11]

[Microsoft][ODBC SQL Server Driver][SQL Server]将数据类型 varchar 转换为numeric 时出错。 行 80

[chunchun_11]

size改为[size]怎么改啊，我试了，还是报错，给我写个例子吧，谢谢！

[qbquan]

用RESPONSE.WRITE()在页面上打印出SQL语句
复制到查询分析器里就知道了

[leohuang]

那些数值型字段,如果为空的话你要改成0

[chunchun_11]

sql1="insert into tblDiagPI_Q(PRODUCTID,PRODUCTLEVELID,PURCH_Q_TYPE,PURCH_INT_SCALE,FRQ_Q_TYPE,FRQ_SCALE) values('"+PRODUCTID+"','"+PRODUCTLEVELID+"','"+PURCH_Q_TYPE+"','"+PURCH_INT_SCALE+"','"+FRQ_Q_TYPE+"','"+FRQ_SCALE+"')"
用RESPONSE.WRITE()在页面上打印出SQL语句
复制到查询分析器里出现了第 1 行: ',' 附近有语法错误。
我找了半天也没找出来哪里错了。

[chunchun_11]

急！！高手快帮帮我！！

[李睿_Lee]

你要把sql1变量的内容输出，这样容易看出问题所在。

[chunchun_11]

还是没找到，怎么办

[chunchun_11]

顶

[cow8063]

用RESPONSE.WRITE()在页面上打印出SQL语句
复制到查询分析器里就知道了


对