Question

sql="select * from products" sql=sql & "where productid in (" & productlist & ")" sql=sql & " order

请高手指点一下有什么错误

Answer 1

sql="select * from products"
sql=sql & "where productid in (" & productlist & ")"
sql=sql & " order

如果：是我上边的格式则有
　第二行，第一引号后个少了空格(英文空格)
第三行，order 应为ORDER BY XXXX(也就是排序)
还有，不知你变量 productlist 　有没问题
如果不是很长　没必要老用 tsql= tsql & ...　语句太长还不如用　续行符 "& _" 一目了然
改为：

sql="select * from products" & _"
sql=sql & " where productid in (" & productlist & ")"
sql=sql & " order by productid"
或者
sql="select * from products" & _"
" where productid in (" & productlist & ")" & _"
" order by productid"

Answer 2

sql=sq1
不一样啊

Answer 3

sql=sq1
不一样啊