Question

ASP字符串与变量拼接问题！急用！谢谢！！

'变量定义
sql="insert into 影片(片名,分类,推荐指数,地区,年代,导演,主演,简介,视频格式,视频大小,链接)values("+ypm+","+fl+","tjzs+","+dq+","+nd+","+dy+","+zy+","+nrjj+","+spgs+","+spdx+","+xzdz+")"
conn.execute sql
错误提示：语句未结束！
请问哪里有问题？

Answer 1

sql="insert into 影片(片名,分类,推荐指数,地区,年代,导演,主演,简介,视频格式,视频大小,链接)values("+ypm+","+fl+","+tjzs+","+dq+","+nd+","+dy+","+zy+","+nrjj+","+spgs+","+spdx+","+xzdz+")"
,"tjzs+",
这里前面少了个+.
如果你不是用VBS的话,用+可以,但如果你用VBS,应该把+改成&