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:
[delete] problem (1997)
OT - royalty free images (2002)
ShowCart Errors (2000)
Loss in form (1998)
Need formum software... (2003)
Multiple email troubles (2001)
searchable list archive (1997)
did I miss anything (1997)
RE: WebCat: Access denied, but why? - The solution. (1997)
I'm new be kind (1997)
Web*SSL and WebCatalog (1997)
WebCatalog2 Feature Feedback (1996)
Setting up the server (1997)
Explorer 3.0/ Access Denied! (1997)
Auto Web Pages (1999)
Strange WebDNA server not running error (2006)
Javascript/WebCatalog form population (2001)
Need relative path explanation (1997)
Re:listfiles-looking for slick solution (1997)
More Applescript (1997)