UC知道ASP中Insert into 语句错误
来源：百度知道 编辑：UC知道 时间：2024/05/12 11:32:52
ACCESS数据库，其中c_id为是/否类型数据，biaoti,dalei,xiaolei,sddanwei,jgdanwei,word,tianshu,tupian,username,dizhi,email为文本型数据，counter,jiage,dianhua,youbian为数字数据
sql="insert into news(c_id,biaoti,dalei,xiaolei,counter,sldanwei,jiage,jgdanwei,word,tianshu,tupian,username,dianhua,dizhi,email,youbian)values("+c_id+",'"+biaoti+"','"+dalei+"','"+xiaolei+"',"+counter+",'"+sldanwei+"',"+jiage+",'"+jgdanwei+"','"+word+"','"+tianshu+"','"+tupian+"','"+username+"',"+dianhua+",'"+dizhi+"','"+email+"',"+youbian+")"
conn.execute sql
conn.close
set conn=nothing
提示“sql=……”那一行语法错误，我检查了N遍了，就是不行，请教高手！！！！
sql="insert into news(c_id,biaoti,dalei,xiaolei,counter,sldanwei,jiage,jgdanwei,word,tianshu,tupian,username,dianhua,dizhi,email,youbian)values("+c_id+",'"+biaoti+"','"+dalei+"','"+xiaolei+"',"+counter+",'"+sldanwei+"',"+jiage+",'"+jgdanwei+"','"+word+"','"+tianshu+"','"+tupian+"','"+username+"',"+dianhua+",'"+dizhi+"','"+email+"',"+youbian+")"
conn.execute sql
conn.close
set conn=nothing
提示“sql=……”那一行语法错误，我检查了N遍了，就是不行，请教高手！！！！
把sql输出看看，或许你自己就知道这么改了：
......
response.write sql
response.end
conn.execute sql
sql="insert into news(c_id,biaoti,dalei,xiaolei,counter,sldanwei,jiage,jgdanwei,word,tianshu,tupian,username,dianhua,dizhi,email,youbian)values(0"+cstr(c_id)+",'"+biaoti+"','"+dalei+"','"+xiaolei+"',0"+cstr(counter)+",'"+sldanwei+"',0"+cstr(jiage)+",'"+jgdanwei+"','"+word+"','"+tianshu+"','"+tupian+"','"+username+"',0"+cstr(dianhua)+",'"+dizhi+"','"+email+"',0"+cstr(youbian)+")"
sql="insert into news(c_id,biaoti,dalei,xiaolei,counter,sldanwei,jiage,jgdanwei,word,tianshu,tupian,username,dianhua,dizhi,email,youbian) values('"+c_id+"','"+biaoti+"','"+dalei+"','&