Cascading Menus

Hi All,

What I want to do is create a cascading menu that reads from a database. I have searched through google and the likes and have come up with exactly nothing so my question is does anyone know where I can get some source code that creates a cascading menu that reads from a database??

Any help on this would be greatly appreciated!!!

Thanks

Vicki

Would that help? Is that what you try to do?


<%
set rsName = Server.CreateObject("ADODB.RecordSet")
rsName.Open "SELECT data FROM table", Conn
%>

<SELECT name="nameOfTheDropdownList">
<OPTION VALUE="defaultValue" SELECTED>all data:
<% while not rsName.EOF %>
<OPTION VALUE="<%=rsName.Fields("data").Value%>"><%=rsName.Fields("data").Value%>
<%
rsName.moveNext
wend
%>
</SELECT>



<%
rsName.Close
set rsName = Nothing
%>