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 WebWarriorsPacific Coast Software | WebCatalog, WebCommerce Solution11770 Bernardo Plaza Court, #462 | SiteEdit, SiteCheck, PhotoMasterSan 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.comwith BODYunsubscribe 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 WebWarriorsPacific Coast Software | WebCatalog, WebCommerce Solution11770 Bernardo Plaza Court, #462 | SiteEdit, SiteCheck, PhotoMasterSan 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.comwith BODYunsubscribe 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:
New WebCatalog Version !!! (1997)
WebDNA Solutions ... (1997)
Showif for mulitple variations (1997)
WebCat for Unix?? (1997)
typhoon... (1997)
Almost a there but..bye bye NetCloak (1997)
Pull Down Search (2000)
[Announce]: Web server security and password protection (1997)
popups, netscape vs explorer (1997)
Setting up shop (1997)
Drop Down Menus (2002)
New Webcatalog for Mac (1997)
WebCat2b12 CGI Mac - [shownext] problem (1997)
Is there an alternative to emailer? (1999)
WebCat2b13MacPlugIn - More limits on [include] (1997)
Bug or syntax error on my part? (1997)
WC2f3 (1997)
A workaround for handling date range search in yyyy/mm/dd form (1997)
SKU number. (2000)
multiple prices (1998)