asp and dropdown list with database

[news]

Hello,

I need help with the following problem:



An HTML page that have two dropdown list whit different values:

1. Dropdown list 1(tblname1) =values with different location's. After user
has selected one value from the dropdown it should show values from
(tblname2) in the dropdown list2.

2. When user select an value from dropdown list2(tblname2) and click on a
button "GO" it should show all the value's from the database that been
selected in dropdown list1 and 2.



Please someone please help me out with this problem!?



Regards,

Kenneth

 

[Ray Costanzo [MVP]]

<select
onchange="location.href='<%=Request.ServerVariables("SCRIPT_NAME")%>?id='+th
is.value;">
<% '' your code that puts in options %>
</select>

<%

iSelectedID = Request.Querystring("id")
If Not iSelectedID = "" Then
''your code to get other values for second box
sSQL = "SELECT stuff FROM table2 WHERE foreignkey=" & iSelectedID
End If
%>
<select>
<% 'your code that loops through that second recordset if it was populated
%>

For more detailed examples, see here:
http://www.aspfaq.com/show.asp?id=2270

Ray at work