INSERT INTO 语句的语法错误，应该也没有关键字了。
conn.execute( "insert into products (pid,pname,spic,bpic,auctions,Authors,Creationss,Notes,xingshi,Textures,psize,Signeds,Valuations,Prices,ling,kuan,yztime,yzadd,pmtime,pmadd,Contents) values( "&pid& ", ' "&pname& " ', ' "&spic& " ', ' "&bpic& " ', ' "&auctions& " ', ' "&Authors& " ', "&Creationss& ", "&Notes& ", "&xingshi& ", "&Textures& ", "&psize& ", "&Signeds& ", "&Valuations& ", "&Prices& ", "&ling& ", "&kuan& ", "&yztime& ", "&yzadd& ", "&pmtime& ", "&pmadd& ", "&Contents& ") ")
[解决办法]
conn.execute "insert into products (pid,pname,spic,bpic,auctions,Authors,Creationss,Notes,xingshi,Textures,psize,Signeds,Valuations,Prices,ling,kuan,yztime,yzadd,pmtime,pmadd,Contents) values( "&pid& ", ' "&pname& " ', ' "&spic& " ', ' "&bpic& " ', ' "&auctions& " ', ' "&Authors& " ', "&Creationss& ", "&Notes& ", "&xingshi& ", "&Textures& ", "&psize& ", "&Signeds& ", "&Valuations& ", "&Prices& ", "&ling& ", "&kuan& ", "&yztime& ", "&yzadd& ", "&pmtime& ", "&pmadd& ", "&Contents& ") "
[解决办法]
strSQL= "insert into products (pid,pname,spic,bpic,auctions,Authors,Creationss,Notes,xingshi,Textures,psize,Signeds,Valuations,Prices,ling,kuan,yztime,yzadd,pmtime,pmadd,Contents) values( "&pid& ", ' "&pname& " ', ' "&spic& " ', ' "&bpic& " ', ' "&auctions& " ', ' "&Authors& " ', "&Creationss& ", "&Notes& ", "&xingshi& ", "&Textures& ", "&psize& ", "&Signeds& ", "&Valuations& ", "&Prices& ", "&ling& ", "&kuan& ", "&yztime& ", "&yzadd& ", "&pmtime& ", "&pmadd& ", "&Contents& ") "
Response.Write strSQL
Response.end
conn.execute strSQL
打印出来这条SQL语句就知道了，是不是字符型的字段插入内容时没有加单引号
[解决办法]
应该是数据类型的问题
[解决办法]
插入的数据中,有 '号没过滤.
