VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-Cart StoreFront Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

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

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")

response.write "<table border=1 cellpadding=5 cellspacing=5 bordercolor=#000000 bgcolor=#dddaaa >"
Do While Not rs.EOF and count<10
<td><font size="2"><a href="shopdisplayproducts.asp?id=<%= rs("categoryid") %>"><%= rs("catdescription") %></a></font><br></td>
<% count=count+1
conn.Close %>

  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000