Using the split () function to generate SQL query statements in ASP

Split Program code


<%attribs= "Market Name ^ ^ fast-food restaurant name ^"
Names=split (Attribs, "^^")
I=0
For each name in names
Response.Write Names (i) & "<br>"
I=i+1
Next%>

Program Split Result:
Store Name
Snack Bar Name
Name of the newspaper stop




Generate SQL statement based on Split result


<%attribs= "Market Name ^ ^ fast-food restaurant name ^"
Names=split (Attribs, "^^")
I=0
Sql= "SELECT Top * from tablename where"
For each name in names
If names (i) = "Mall name" then
Sql=sql+ "or arcade like '%" &names (i) & "%"
End If
If names (i) = "Snack Bar name" then
sql=sql+ "or fast food like '%" &names (i) & "%"
End If
If names (i) = "Newspaper Stop name" then
sql=sql+ "or fast food like '%" &names (i) & "%"
End If
I=i+1
Next
sql=sql+ "Ordey by Id DESC"
Sql=replace (SQL, "Where or", "where")
Response.Write sql%>

Program Run Result:
Select Top * FROM TableName where arcade like '% Shop name% ' or fast food restaurant like '% fast food restaurant name% ' or fast food '% ' Ordey by Id DESC