Re: price formula
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22358
interpreted = N
texte = >I have a database of items. I have the textC field set to input the>size of the item. I the want to increment the price up a dollar when>textC = XX-Large. What is the code of for this in the formula.db?>>I tried something like this> [showif [textC]=XX-Large][math][lookup...price]+1.00[/math][/showif]Boy, that sure looks right. What's not working? It should be as simple as:-- Formulas.db --price [math][price][ShowIf [textC]=XX-Large]+1[/ShowIf][/math]This does [math][price][/math] for normal sizes, and [math][price]+1[/math]for XX-LargeTechnical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>I have a database of items. I have the textC field set to input the>size of the item. I the want to increment the price up a dollar when>textC = XX-Large. What is the code of for this in the formula.db?>>I tried something like this> [showif [textC]=XX-Large]
[math][lookup...price]+1.00[/math][/showif]Boy, that sure looks right. What's not working? It should be as simple as:--
formulas.db --price
[math][price][ShowIf [textC]=XX-Large]+1[/ShowIf][/math]This does
[math][price][/math] for normal sizes, and
[math][price]+1[/math]for XX-LargeTechnical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
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:
RE: [WebDNA] [AddFields] Restrictions (2012)
Sku numbers (1997)
Missing contexts on NT (1997)
remotely add + sign (1997)
AND/OR searches in WebCat 3.07 (2003)
Re1000001: Setting up shop (1997)
Formulas.db + Users.db (1997)
It finally happened ... (2003)
Error Log.db --however (1997)
Trouble with formula.db (1997)
Best Platform (2000)
searching with if/then (2004)
[WebDNA] WebDNA Start-up Error (2012)
WC2b15 File Corruption (1997)
problems with 2 tags (1997)
Re:Emailer and encryption (1997)
webcat- multiple selection in input field (1997)
downloading binary files ussing mime and tcpconnect (2004)
Orders w/in [sendmail] (1998)
can webcat determine an image's pixel dimensions? (2000)