'接受多选景点 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