2 dynamic drop down boxes from database

[alexz]

I'm populting one box from a table called category.
I want to create another box that would be populated subcatagories
from the subcategory table based on the selection from category.

This the code for the first drop down

<form method="Post" action="add.asp" onsubmit="return
status_checker()" name="search">
<SELECT NAME="Category_ID" ONCHANGE=search.submit()>
<%
Dim MyConn, RS, SQLcmd
Set MyConn=Server.CreateObject("ADODB.Connection")
MyConn.Open "media"
Set RS=Server.CreateObject("ADODB.RecordSet")
SQLcmd = "SELECT * From Categories"
RS.Open SQLcmd, MyConn,1
do until rs.eof
response.write "<option value=""" & rs("ID") & """>"
response.write rs("Category")
response.write "</option>"
rs.movenext
loop
rs.close
%>
</select>

This query should go into the second dropdown box.

SQLcmd = "SELECT Subcategories.CategoryID, Subcategories.SubCategory
FROM Subcategories WHERE (((Subcategories.CategoryID)=" &
request("Category_ID") & "))"

I also should be able to submit the selections to the add.asp page

Thanks

[Bullschmidt]

Here is one idea (refreshing the page) about that:

ASP Design Tips - Dependent Listboxes
[url]http://www.bullschmidt.com/devtip-dependentlistboxes.asp[/url]

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!