Re: select menus & database design

This WebDNA talk-list message is from

1998

It keeps the original formatting. numero = 17802
interpreted = N
texte = >We have a database of products for sale which is working fine. Some (not>all) 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-large>teal 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 6>colors and 4 sizes for many products, our product list is getting>absurdly long, and not particularly user-friendly to navigate.>>What we'd like is for our search results template to recognize when a>product has size and color options, and to generate a menu>which 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?>Check out www.kickpunch.com look under uniforms, and see if this issomething like what you want. Brian B. Burton BOFH - Department of Redundancy Department--------------------------------------------------------------- MMT Solutions - Specializing in Online Shopping Solutions 973-808-8644 http://www.safecommerce.com 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 (not>all) 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-large>teal 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 6>colors and 4 sizes for many products, our product list is getting>absurdly long, and not particularly user-friendly to navigate.>>What we'd like is for our search results template to recognize when a>product has size and color options, and to generate a menu>which 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?>Check out www.kickpunch.com look under uniforms, and see if this issomething like what you want. Brian B. Burton BOFH - Department of Redundancy Department--------------------------------------------------------------- MMT Solutions - Specializing in Online Shopping Solutions 973-808-8644 http://www.safecommerce.com Brian B. Burton

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:

Don't tick me off :) [elaspedtime] (1997) Search for 20 finds 2000, 200 Why? (1997) Share Bulletin Board? (1998) CMSBuilder (2004) Signal Raised error (1997) Help with sorting search results sorting (1998) Mac Vs WindowsNT (1997) Browser compatibility (Was: Search Engine bots) (2002) [WebDNA] UPS integration (2008) What am I missing (1997) WebCatalog2 Feature Feedback (1996) [OT] Industry news from Australia (2000) Multiple prices (1997) Ooops-Serial Number for NT (1997) [WebDNA] [BULK] strange triggers.db occurrence??? (2012) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) Emailer again & again (1997) webcat NT (1998) WebCat2_Mac RETURNs in .db (1997) Help needed! (1998)