Printable View
Hi,
I am VERY,VERY new to asp-ado and need some help please.
I want to put a dropdown box on my page with all the different countries as options. The user can then choose the country he wants to view and I want to then
select * from table where country = "the country the user picked from the dropdown"
My problem is how to get whatever the user selected into a variable which I can then use in my sql query
Thank you,
you will have to use two pages:
1. with a regular HTML extention that will have a form:
<html>
<head><title>My Country</title></head>
<body>
<form method="post" action="showinfo.asp">
Please choose the country:
<select name="thecoutry">
<option value="A">A</option>
<option value="B">B</option>
<option value="C">C</option>
</select>
<input type="submit" value="go">
</form>
</body>
</html>
2.
The ASP page (showinfo.asp)
<%
dim CountryName
CountryName=trim (request.form ("thecountry")) ' this will get the name of the country the user choosed on the previous page
strSQL = "set rowcount 0 select country from CountryTable where country=" & CountryName
....
%>
Hope it helped..
It depends.. Where do you need the data from the query to be displayed? If you need it on the same page, you can setup an event for the select tag that reloads the page passing the value of the select with a querystring back to itself. In the beginning code of the page, check for the existence of the querystring and use it in the query.
If you need it in another page, add a submit button and set the action attribute to the new page and a method=post in the FORM tag. Make sure you use the name attribute in your select tag or you won't be able to get the data out of the Form collection.