如有一个参数:
likestr = "参数1,参数2,参数3"
我在现要让sql查询语句与上面的变量里“,”号间的参数一一区配,我是这样写的:
dim sqlparam
sqlparam = "where id > 0 "
myarray = split(likestr,",")
for i = 0 to ubound(myarray)
sqlparam = sqlparam & " or title like '%" & myarray(i) & "%' "
next
然后完整的sql语句就是 "select * from news " & sqlparam
上面是利用程序把sql语句拼写完整的,那有没有更简单的方法,类似于 in()这类的方法,直接在sql里面就能实现的多条件模类匹配查询。
可以用替换的方法:likestr = "参数1,参数2,参数3"likestr=replace(likestr,",","%' or title like '%")sql="select * from news where title like '%"&likestr&"%'"response.Write(sql)