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 -- What formula are you using it in...? Is that shipCost? If so -- there was earlier discussion about quantity not being valid in shipCost - you need a [lineitems] loop to get to the individual items - which would get you to the 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 & Development Suite 453 | http://www.smithmicro.com San 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 -- What formula are you using it in...? Is that shipCost? If so -- there was earlier discussion about quantity not being valid in shipCost - you need a
[lineitems] loop to get to the individual items - which would get you to the 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 & Development Suite 453 | http://www.smithmicro.com San 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:
Showif, Hideif reverse logic ? (1997)
RandSeed (2003)
[format 40s]text[/format] doesn't work (1997)
can WC render sites out? (1997)
Using Cookie for client specific info? (1997)
Test (2004)
Problems getting parameters passed into email. (1997)
WebCatalog [FoundItems] Problem - AGAIN - (1997)
[WebDNA] [BULK] ampps.com - let webdna be included (2011)
remotely add + sign (1997)
syntax question, not in online refernce (1997)
Un[url]ize (1999)
New public beta available (1997)
Case sensitivity and [showif] (1999)
Re:listfiles-looking for slick solution (1997)
HTML mapped to WebCat (2001)
NetCloak as Emailer substitute? (1999)
Time Tracking (2003)
Stopping bad HTML propagation ? (1997)
Questions To Answer (1997)