Question

ODBC Microsoft Access Driver] 语法错误 (操作符丢失)

<%
response.end
end if
sql="insert into produit(id_bigclass,id_smallclass,title,huohao,id_ku,shulian,danwei,price,guige,baojin,class,duihuan,tichen_type,tichen) values("&nowbigclass&","&nowsmallclass&",'"&nowtitle&"','"&nowhuohao&"',"&nowku&","&nowshulian&",'"&nowdanwei&"',"&nowprice&",'"&nowguige&"',"&nowbaojin&","&nowclass&","&nowduihuan&","&nowtichen_type&","&nowtichen&")"
conn.execute(sql)
sql="select * from produit order by id desc"
set rs_produit=conn.execute(sql)
sql="select bigclass from bigclass where id="&nowbigclass
set rs_bigclass=conn.execute(sql)
sql="select smallclass from smallclass where id="&nowsmallclass
set rs_smallclass=conn.execute(sql)
sql="select ku from ku where id="&nowku
set rs_ku=conn.execute(sql)
sql="insert into buy(id_produit,bigclass,smallclass,title,huohao,ku,shulian,price,guige,login,type,selldate) values("&rs_produit("id")&",'"&rs_bigclass(0)&"','"&rs_smallclass(0)&"','"&nowtitle&"','"&nowhuohao&"','"&rs_ku(0)&"',"&nowshulian&"',"&nowprice&",'"&nowguige&"','"&nowlogin&"',0,#"&date()&"#)"
conn.execute(sql)
%>
Microsoft VBScript 编译器错误 错误 '800a03f6'

缺少 'End'

/iisHelp/common/500-100.asp，行242

Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'

[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 '50',60,'','admin',0,#2007-11-7#)' 中。

/produit/produit_add.asp，行121

若以下回答无法解决问题，邀请你更新回答

Answer 1

我来看看，

缺少End看起来是语法错误，但这个问题事实上很有可能是你 单引号 双引号没有配对造成的。

不知道说的对不对！:)