Re: Repeating Fields

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12952
interpreted = N
texte = >I need to store along with each SKU, a list of modifiers (in my case >Keys) which modify the product. For instance, Song X can be purchased in >8 different keys. On the results page I want to have the user use a >pop-up menu to select the key for a song, which will be transferred to >TextA for the cart when they Add. Should I just create a database which >looks something like: >SKU Key >1 Ab >1 Bb >1 C >2 F >2 F# >2 EYes, you should use 2 databases: one for the basic list of products and prices, and the other for the variations. Your main product database should have only 1 SKU listed, but the secondary lookup database can have as many as you want.-- catalog.txt -- SKU title price 1 xxx 5.95 2 yyy 10.95-- Variations.db -- SKU Key 1 Ab 1 Bb 1 C 2 F 2 F# 2 ESo then to list the variations on sku 2 in a popup:[Key] [/foundItems] [/search] Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. Re: Repeating Fields (Grant Hulbert 1997)
  2. Repeating Fields (netmouse@summit1.com (Anne K. Gay) 1997)
  3. Re: Repeating Fields (Grant Hulbert 1997)
  4. Re: Repeating Fields (Olin 1997)
  5. Repeating Fields (Michael Bohan 1997)
>I need to store along with each SKU, a list of modifiers (in my case >Keys) which modify the product. For instance, Song X can be purchased in >8 different keys. On the results page I want to have the user use a >pop-up menu to select the key for a song, which will be transferred to >TextA for the cart when they Add. Should I just create a database which >looks something like: >SKU Key >1 Ab >1 Bb >1 C >2 F >2 F# >2 EYes, you should use 2 databases: one for the basic list of products and prices, and the other for the variations. Your main product database should have only 1 SKU listed, but the secondary lookup database can have as many as you want.-- catalog.txt -- SKU title price 1 xxx 5.95 2 yyy 10.95-- Variations.db -- SKU Key 1 Ab 1 Bb 1 C 2 F 2 F# 2 ESo then to list the variations on sku 2 in a popup:[Key] [/foundItems] [/search] Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Grant Hulbert

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:

RE: Formulas.db + Users.db (1997) taxTotal, grandTotal (1997) Semi-OT: Update forms not working remotely (2002) can WC render sites out? (1997) Generating Report Totals (1997) File Upload (1997) shipcost (1997) Changing Global template settings (2002) WebCat on Apache vs Webstar 5 (2002) [SMSI] WebDNA is too good to go away! (2006) Hiding URL ? (1998) Handy Browser Counter Tip (1997) serial number dishing (1997) users.db (1999) Web Catalog 2 demo (1997) [WebDNA] maybe silly suggestion? [founditems] (2015) problems with 2 tags shakur (1997) WebCatalog can't find database (1997) E-mail Attachments (1997) [WebDNA] feature requests (2008)