Welcome, Guest ( Customer Panel | Login )




 All Forums
 VPCart Forum
 Customization
 Display Categories
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

razorsharp-
Starting Member

4 Posts

Posted - March 28 2003 :  16:55:11  Show Profile  Reply with Quote
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>

  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00