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:

Running _every_ page through WebCat ? (1997) Converting DOS database (2000) time sort question (2005) Email/Order to fax? (2003) suffix mapping, use of cache, etc. (1997) Permissions Ignored - PLEASE HELP (2003) Search returns all, not 20 (1997) [WebDNA] New Upload Tool (2009) 100% cpu load (2006) WC2b15 File Corruption (1997) [OT] Bad Hard Drive? (2003) ShowNext (1997) AuthorizeNet SSL Update (2004) Error & Problem (1997) hidden databases (2000) change the number format (1997) [WebDNA] XML Parsing Error Help (2010) Which WebCat is it? (2000) WebDNA 5.x & iTools 7 & Apache 2 (2003) Newbie problem blah blah blah (1997)