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:
writefile to create static pages (2003)
WebCatalog/Mac 2.1b2 New Features (1997)
how many users (2000)
WebCat2 Append problem (B14Macacgi) (1997)
[WebDNA] multi hyperlinks in text paragraphs (2014)
OrderFile (2000)
SKU (1997)
database paths/names, and a typo (1997)
New NT beta available (1997)
resorting found set (2005)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
OFF TOPIC: Sendmail problem (2003)
Netscape v. IE (1997)
RE: webcat license???? (1997)
WebDNA Windows 5.0 sendmail bug (2003)
auction system w/ Web Cat (1999)
Add htmlarea 3 to SiteBuilder (2004)
Fun with dates (1997)
Finding max value for a field (1997)
date (1999)