select menus & database design

This WebDNA talk-list message is from

1998

It keeps the original formatting. numero = 17797
interpreted = N
texte = We have a database of products for sale which is working fine. Some (notall) of the products come in different sizes and colors. At this point,they are all in our database as separate products. e.g., an extra-largeteal backpack is a different product than the medium maroon backpack.With just a few options for each product, this isn't so bad. But with 6colors and 4 sizes for many products, our product list is gettingabsurdly long, and not particularly user-friendly to navigate.What we'd like is for our search results template to recognize when aproduct has size and color options, and to generate a menuwhich shows the appropriate options.What would be a good database/template design to create such a feature?Does anyone have any working examples we could learn from?Mark Mesenko-Webmaster-Internet Connect Services2700 Radio WayMissoula, Montana 59802406-541-4952webmaster@montana.comhttp://www.montana.com/icshttp://www.montana.com/showcase Associated Messages, from the most recent to the oldest:

Re: select menus & database design (J. Masterson 1998) Re: select menus & database design (Kenneth Grome 1998) Re: select menus & database design (Brian B. Burton 1998) select menus & database design (Mark Mesenko 1998)

We have a database of products for sale which is working fine. Some (notall) of the products come in different sizes and colors. At this point,they are all in our database as separate products. e.g., an extra-largeteal backpack is a different product than the medium maroon backpack.With just a few options for each product, this isn't so bad. But with 6colors and 4 sizes for many products, our product list is gettingabsurdly long, and not particularly user-friendly to navigate.What we'd like is for our search results template to recognize when aproduct has size and color options, and to generate a menuwhich shows the appropriate options.What would be a good database/template design to create such a feature?Does anyone have any working examples we could learn from?Mark Mesenko-Webmaster-Internet Connect Services2700 Radio WayMissoula, Montana 59802406-541-4952webmaster@montana.comhttp://www.montana.com/icshttp://www.montana.com/showcase Mark Mesenko

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

using showpage and showcart commands (1996) Database Erroe (2000) unitshipcost vs shipcosts (1997) More questions about serial number dishing (1997) Cyberstudio and WebDNA (1997) error: Too many nested [xxx] contexts (1997) [dos] command question (1997) Mac -Shareware Listserver (1998) WC1.6 to WC2 date formatting (1997) Limit on nested [ShowIf]'s? (1997) Caching [include] files ... (1997) [writefile] (1997) Nav. 4 probs with cart - Serious problem (1997) calender with business days (1998) Setting up shop (1997) Email encryption (1998) [BULK] [WebDNA] [if] or [case] or something else (2012) Lookup within a Search (2005) [Announce] Newest Commerce Site based on WebCatalog (1997) Fed Ex Rate Charts (2003)