Re: Filtering Pulldown Select Lists

In your asp page for products only call products where family = x

For your parts page only call parts where products = y

e.g.

Set RSs = Server.CreateObject("ADODB.Connection")
' Get the items out of the systems DB
mySql = "SELECT tbl_Parts.* FROM  tbl_Parts WHERE products=3"
Set RSs = Conn.Execute(mySql)

HTH

Andy

----- Original Message ----- 
From: "Melanie Gann" <mgann(at)second-street.com>
To: <hwg-techniques(at)hwg.org>
Sent: Wednesday, April 10, 2002 8:44 PM
Subject: ASP: Filtering Pulldown Select Lists


> I have a product hierarchy:
> 
>          Product Family-+
>                         |
>                         Products--+
>                                   |
>                                   Parts
> 
> The user selects the Product family, and I want to filter the next
> select list to products in that family. Likewise I want the parts
> select list to belong only to that product.
> 
> Javascript allows you do to this nicely with arrays. However, I want to
> use data from the database.
> 
> Any advice (or articles you can point me to) is appreciated.
> 
> Regards,
> Melanie
> 
>        
> 
> Second Street Web Design
> http://www.second-street.com
> 
> 

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA