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 price1 xxx 5.952 yyy 10.95-- Variations.db --SKU Key1 Ab1 Bb1 C2 F2 F#2 ESo then to list the variations on sku 2 in a popup:
[search db=Variations.db&eqSKUdata=2][foundItems][Key][/foundItems][/search] Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors =====Pacific Coast Software | WebCatalog Pro, WebCommerce Solution11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMasterSan Diego, CA 92128 | SiteGuard619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
>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 price1 xxx 5.952 yyy 10.95-- Variations.db --SKU Key1 Ab1 Bb1 C2 F2 F#2 ESo then to list the variations on sku 2 in a popup:[search db=Variations.db&eqSKUdata=2][founditems] [Key][/foundItems][/search] Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors =====Pacific Coast Software | WebCatalog Pro, WebCommerce Solution11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMasterSan Diego, CA 92128 | SiteGuard619/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)