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:

[WebDNA] WebDNA programmers for hire? (2010) [dos] command question (1997) Summary Searches (2000) Authorize.Net (2003) Help!!!! (1997) Searching Relational Databases (2004) [format 40s]text[/format] doesn't work (1997) Upgrade to 3.07 problems (2000) Convert characters (2002) WebCat2 as a chat server? (1997) Access Denied! But why? (1997) OT: Help Wanted/Stowe, Vermont (1999) Multiple security dbs (1997) WebCat 5 Intranet Question (2003) TeaRoom Order fields email account remain empty even though thewy are filled. (1997) question: back button prevention (1997) Nesting format tags (1997) How to set suffix mapping on IIS 5.1 ... (2004) Hiding URL ? (1998) Visitor info (2000)