Re:Formulas.db / Quantity Discount problem
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16768
interpreted = N
texte = Sounds like quantity is what is giving you an incorrect value -- Whatformula are you using it in...? Is that shipCost? If so -- there wasearlier discussion about quantity not being valid in shipCost - you need a[lineitems] loop to get to the individual items - which would get you tothe quantity...Does this make sense...?>Hi All,>>[showif] does not seem to be working for me in the formulas.db.>>I am trying to setup a formula for price that subtracts a discount ammount>from the regular price if the quantity is greater than a certain ammount.>>This works when I enter it on the invoice.tmpl page:>[math][lookup>db=z-b.db&lookInField=sku&value=[sku]&returnField=peritemprice][showif>[quantity]>[pricebreakpoint]]-[lookup>db=z-b.db&lookInField=sku&value=[sku]&returnField=discountammount][/showif]0+0[>/>math]>>But when I put it in the Formulas.db it returns the regular price less the>discount ammount regardless of the quantity. It seems to be ignoring the>[showif] tag that qualifies the quantity.>>Any ideas?>>TIA, PaulJay Van Vark *******************************Pacific Coast Software | eCommerce (WebCatalog)11770 Bernardo Plaza Court | Site Hosting & DevelopmentSuite 453 | http://www.smithmicro.comSan Diego, CA 92128 *******************************619.675.1106** PGP key available upon request. **
Associated Messages, from the most recent to the oldest:
Sounds like quantity is what is giving you an incorrect value -- Whatformula are you using it in...? Is that shipCost? If so -- there wasearlier discussion about quantity not being valid in shipCost - you need a
[lineitems] loop to get to the individual items - which would get you tothe quantity...Does this make sense...?>Hi All,>>
[showif] does not seem to be working for me in the
formulas.db.>>I am trying to setup a formula for price that subtracts a discount ammount>from the regular price if the quantity is greater than a certain ammount.>>This works when I enter it on the invoice.tmpl page:>
[math][lookup>db=z-b.db&lookInField=sku&value=[sku]&returnField=peritemprice][showif>[quantity]>[pricebreakpoint]]-[lookup>db=z-b.db&lookInField=sku&value=[sku]&returnField=discountammount][/showif]0+0[>/>math]>>But when I put it in the
formulas.db it returns the regular price less the>discount ammount regardless of the quantity. It seems to be ignoring the>
[showif] tag that qualifies the quantity.>>Any ideas?>>TIA, PaulJay Van Vark *******************************Pacific Coast Software | eCommerce (WebCatalog)11770 Bernardo Plaza Court | Site Hosting & DevelopmentSuite 453 | http://www.smithmicro.comSan Diego, CA 92128 *******************************619.675.1106** PGP key available upon request. **
Jay Van Vark
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:
[WebDNA] WebDNA & Google Chrome Browser (2012)
Conversion Database Blues (2001)
[OT] - See my site? (2004)
WebCat for mass emailings (1997)
[protect admin] (1997)
cart ID (1998)
Frames and WebCat (1997)
X etc.... (1999)
2.0Beta Command Ref (can't find this instruction) (1997)
WebCat2: Items xx to xx shown, etc. (1997)
WebCatalog NT beta 18 problem (1997)
[SHOWIF] (1997)
[WebDNA] Using [PROTECT] (2013)
WebCat2 - [format thousands] (1997)
WebCat for Site Search? (1997)
Problems with WebCat 4.01 (2000)
WCS Newbie question (1997)
Physical Security for WebCatalog Directories (1997)
WebDNA programmers needed (1998)
New public beta available (1997)