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:

PCS Frames (1997) Searching multiple Databases (1997) Internet Explorer and caching (2000) [WriteFile] problems (1997) Satisfy Me ! was: Why can't support be satisfying to (2000) [sendmail] on NT? (1997) OS X and cart directories (2003) FEW QUESTIONS (1997) WebCat2: Items xx to xx shown, etc. (1997) Submit buttons not working.... (1999) Sort Order on a page search (1997) Help name our technology! I found it (1997) Line Breaks (2003) EMail Problem (2000) Security Question (1997) unsubscribe (2000) WebCat3.04/w*4/OS8.5.1 and aliases (1999) Header info in content (1998) international time (1997) WebCat NT v. Mac (1997)