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:
More DateMath problems (1997)
Fufillment e-mail? (1998)
Bad suffix error (1997)
Don't know if this is a sily question... (2003)
WCS Newbie question (1997)
Web Catalog 2 demo (1997)
ConvertChars? (1998)
Grep and removing text (2002)
Enhancement Request for WebCatalog-NT (1996)
emailer on Windows Beta 18 (1997)
Talk List Suggestions (1997)
webcat error log (1998)
Webcatalog 4.02b5 Mac OS X headers (2000)
learning PHP (2007)
Multiple catalog databases and showcart (1997)
[isfile] ? (1997)
Separate SSL Server (1997)
suffix mapping for NT? (1997)
Browser Problem?!? POST forms and NN 4.0+ browsers (1997)
WebDNA deletes major DB data big time (2004)