'接受多选景点
attractions=request("attractions")
attraction=split(attractions,", ") '注意:逗号后面有一个空格
'得到多景点的查询条件
ifattraction=""
for i=0 to ubound(attraction)
ifattraction=ifattraction&" and MY_DayScenery like '%"&attraction(i)&"%'"
next
'查询线路
ArticleSql="select * from PE_Article where ChannelID=1001"&ifattraction
set ArticleRs=server.CreateObject("adodb.recordset")
ArticleRs.open ArticleSql,conn,3,2