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:
[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)