razorsharp-
Starting Member
4 Posts |
Posted - March 28 2003 : 16:55:11
|
Hi Can any one help ,
Id like to show my categories as a list box or jump menu the code below works fine in a table but how can i convert into a form so i can use it as list box or jump menu
Can anybody covert the code below
<% Dim dsn Dim conn dim rs dim count dsn=";Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\inetpub\shopping450.mdb" Set conn = Server.CreateObject("ADODB.Connection") conn.Open dsn ' connect to the database Set rs = conn.Execute("SELECT * FROM categories ORDER by catdescription asc")
count=0 response.write "<table border=1 cellpadding=5 cellspacing=5 bordercolor=#000000 bgcolor=#dddaaa >" Do While Not rs.EOF and count<10 %> <tr> <td><font size="2"><a href="shopdisplayproducts.asp?id=<%= rs("categoryid") %>"><%= rs("catdescription") %></a></font><br></td> </tr> <% count=count+1 rs.MoveNext Loop rs.Close conn.Close %> </table>
|
|