Question

asp搜索多个条件的数据问题

我想让以下两个全二为一,应该怎么写?orders是一个变量!
Sql = "select * from xlist "&orders
Sql = "select * from xlist where yd = True and nd =False order

Answer 1

问题是你的orders里面是什么东东？如果也是where条件,就可以并起来
Sql = "select * from xlist
where yd = True
and nd =False " & "and" & orders;