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:
Happy New year (2004)
Database Crash (2001)
Associative lookup style? + bit more (1997)
FYI: virus alert (1996)
WebDNA install on Tiger doesn't work ... (2005)
big database file (2000)
Bannerad Demo (1998)
[append] vs. [appendfile] delta + question? (1997)
calculating tax rates, mail order solutions and version 2 (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Credit card processing - UK (1997)
Okay, I give up... (1999)
best way to limit # of attempts to login to protected page? (2000)
RE: what characters are replaced for tab and CR? (1998)
WebDNA deletes major DB data big time (2004)
Release of 2.01? (1997)
[ot] ShowIf & HideIf Question (1998)
Showing specific [cart] contents (1998)
Problem with Formulas.db (1998)
Freeze (2003)