...

View Full Version : Cascading Menus



vicki_b
11-10-2003, 02:34 AM
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

jeskel
11-10-2003, 10:52 AM
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
%>



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum