Split程序代码
代码如下:
<%attribs="商场名^^快餐店名^^报停名"
names=Split(attribs,"^^")
i=0
foreachnameinnames
response.writenames(i)&"<br>"
i=i+1
next
%>
程序拆分结果:
商场名
快餐店名
报停名
根据Split结果生成SQL语句
代码如下:
<%attribs="商场名^^快餐店名^^报停名"
names=Split(attribs,"^^")
i=0
sql="selecttop10*fromTableNamewhere"
foreachnameinnames
ifnames(i)="商场名"then
sql=sql+"or商场like'%"&names(i)&"%'"
endif
ifnames(i)="快餐店名"then
sql=sql+"or快餐店like'%"&names(i)&"%'"
endif
ifnames(i)="报停名"then
sql=sql+"or快餐店like'%"&names(i)&"%'"
endif
i=i+1
next
sql=sql+"OrdeybyIdDESC"
sql=Replace(sql,"whereor","where")
response.writesql
%>
程序运行结果:
代码如下:
selecttop10*fromTableNamewhere商场like'%商场名%'or快餐店like'%快餐店名%'or快餐店like'%报停名%'OrdeybyIdDESC
|