Discuss "Using Dropdown List Value in Database SQL Query" in the Classic ASP forum.

<form id="form1" name="form1" method="post">
<select id="ddl" name="ddl" size="1">
<option value="yes">Yes</option>
<option value="no">No</option>
</select>
</form>

Dim filter_value
'retrieve the value from the dropdown
filter_value = request.form("ddl")
 
'this is a very simplistic validation of the value received. More complicated versions should be used for complex dropdowns or textboxes.
if filter_value="yes" OR filter_value="no" then
 
      strsql = "SELECT field1,field2,field3 FROM tbl_name WHERE filter_field='" & filter_value & "'"
 
end if