Re: Multiple prices
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 10571
interpreted = N
texte = >Is there an example that shows how to deal with '1 sku Item' having >mutliple prices? I would like my customers to be able to select one of 3 >prices for their selection from both the results and detailed templates. >What say you? We purposely made it a little hard so hackers can't just type any old price they want. It would be nice to simply do $Add?price=[AltPrice2], but then people could just edit the URL and type anything they want.So I recommend you put some extra parameter into your $Add command, and then use the price formula to look up the alternate price.$Add?db=catalog.txt&sku=[sku]&alt=1 $Add?db=catalog.txt&sku=[sku]&alt=2 $Add?db=catalog.txt&sku=[sku]&alt=3Then in Formulas.db: price [lookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=price[alt]]You would then put a price1 price2 and price3 field into your database, and the [alt] above would convert to 1, 2, or 3 depending on which alternate hyperlink they chose.Grant Hulbert, V.P. Engineering | Tools for WebWarriors Pacific Coast Software | WebCatalog, WebCommerce Solution 11770 Bernardo Plaza Court, #462 | SiteEdit, SiteCheck, PhotoMaster San Diego, CA 92128 | 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com ------------------------------------ To leave this talk list send an email to macjordomo@smithmicro.com with BODY unsubscribe WebDNA-Talk ------------------------------------
Associated Messages, from the most recent to the oldest:
>Is there an example that shows how to deal with '1 sku Item' having >mutliple prices? I would like my customers to be able to select one of 3 >prices for their selection from both the results and detailed templates. >What say you? We purposely made it a little hard so hackers can't just type any old price they want. It would be nice to simply do $Add?price=[AltPrice2], but then people could just edit the URL and type anything they want.So I recommend you put some extra parameter into your $Add command, and then use the price formula to look up the alternate price.$Add?db=catalog.txt&sku=[sku]&alt=1 $Add?db=catalog.txt&sku=[sku]&alt=2 $Add?db=catalog.txt&sku=[sku]&alt=3Then in
formulas.db: price [lookup db=catalog.txt&lookInField=sku&value=[sku]&returnField=price[alt]]You would then put a price1 price2 and price3 field into your database, and the [alt] above would convert to 1, 2, or 3 depending on which alternate hyperlink they chose.Grant Hulbert, V.P. Engineering | Tools for WebWarriors Pacific Coast Software | WebCatalog, WebCommerce Solution 11770 Bernardo Plaza Court, #462 | SiteEdit, SiteCheck, PhotoMaster San Diego, CA 92128 | 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com ------------------------------------ To leave this
Talk List send an email to macjordomo@smithmicro.com with BODY unsubscribe WebDNA-Talk ------------------------------------
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:
Frames and WebCat (1997)
Caching [include] files ... (1997)
Generating Report Totals (1997)
ShowNext Command (1997)
Round to the nearest half! (2008)
Tech support (2000)
Setting up shop (1997)
[ShowNext] (1997)
Return records from another (1997)
question: webdelivery folder and file (1997)
Timer Values on [redirect] (1998)
[WebDNA] mail header timezone problem (2008)
no [search] with NT (1997)
transferring password & username (2000)
ExclusiveLock (2000)
[WebDNA] An actual attempt to get WebDNA and MAMP Pro to work - (2018)
Where's Cart Created ? (1997)
Does [Sendmail] create html? (2002)
Shopping carts and reloading pages (1997)
Looking up two prices in database? (1997)