ASP中巧用Split()函数生成SQL查询语句的实例

　　<%attribs="商场名^^快餐店名^^报停名"

　　names=Split(attribs,"^^")

　　i=0

　　for each name in names

　　response.write names(i)&"<br>"

　　i=i+1

　　next

　　%>

　　<%attribs="商场名^^快餐店名^^报停名"

　　names=Split(attribs,"^^")

　　i=0

　　sql="select top 10 * from TableName where"

　　for each name in names

　　if names(i)="商场名" then

　　sql=sql+" or 商场 like '%"&names(i)&"%'"

　　end if

　　if names(i)="快餐店名" then

　　sql=sql+" or 快餐店 like '%"&names(i)&"%'"

　　end if

　　if names(i)="报停名" then

　　sql=sql+" or 快餐店 like '%"&names(i)&"%'"

　　end if

　　i=i+1

　　next

　　sql=sql+" Ordey by Id DESC"

　　sql=Replace(sql, "where or", "where")

　　response.write sql

　　%>

　　select top 10 * from TableName where 商场 like '%商场名%' or 快餐店 like '%快餐店名%' or 快餐店 like '%报停名%' Ordey by Id DESC