On my first page I have an array defined as:
dim selection
selection = Array("name", "city")
On the following ASP page I'm trying to call to those same variables for an SQL query:
dim selection
selection = array(request.form("name"), request.form("city"))
In my SQL query:
sqlstr = "SELECT * from Users where name='" + selection(0) + "' and city= '" + selection(1) + "'
This doesn't work, and I've tried tooling around with it but I can't seem to find a working solution. What am I missing?
See Question&Answers more detail:os