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:
Authenticate Questions (2003)
Removing items from a cart is wonky... (1998)
bug in [SendMail] (1997)
Email within tmpl ? (1997)
Authenticate (1997)
trouble updating records in database (1998)
[WebDNA] v7 problem? (2012)
Snake Bites (1997)
emailer (1997)
Limiting user access to .tmpl files (1997)
Limit to Field Length in DB (1998)
showif field is number (1997)
[WebDNA] How much does it cost now? (2008)
webdna code shows on .htm extensions. (2000)
Multi-processor Mac info ... (1997)
Secure Server basic question... (1997)
Secure Server (1997)
WebCatalog can't find database (1997)
WCf2 and nested tags (1997)
2.0 Info (1997)