Re:Formulas.db / Quantity Discount problem
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16770
interpreted = N
texte = Is [quantity] not a valid field in the formulas.db for price?Paul>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, Paul>>Jay Van Vark ******************************* _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/Paul Uttermohlen, Internet Marketspace, Inc. \_\_\_\_ _/_/_/ mailto:paul@ims1.com - Website Development \_\_\_\_ _/_/_/ Business -
_\_\_\_\_\_\_\_\_\_\_ _/_/_/ Real Estate - _\_\_\_\_ _/_/_/Websites - Children _/ _\_\_\__/_/_/_/_/_/_/_/_/_/_/_/_/_/ | \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
Associated Messages, from the most recent to the oldest:
Is [quantity] not a valid field in the formulas.db for price?Paul>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, Paul>>Jay Van Vark ******************************* _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/Paul Uttermohlen, Internet Marketspace, Inc. \_\_\_\_ _/_/_/ mailto:paul@ims1.com - Website Development \_\_\_\_ _/_/_/ Business - _\_\_\_\_\_\_\_\_\_\_ _/_/_/ Real Estate - _\_\_\_\_ _/_/_/Websites - Children _/ _\_\_\__/_/_/_/_/_/_/_/_/_/_/_/_/_/ | \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
Paul Uttermohlen
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:
Newspaper Portal (2005)
Search Result refinement help (2003)
WebDNA Speed Test (2008)
WYSIWYG Editor? (2006)
Protect vs Authenicate (1997)
[HIDEIF] inside [FOUNDITEM] (1997)
[/application] error? (1997)
NT installation (2000)
killer-format in cart (1998)
Weird search results ?? (2002)
Browser Problem?!? POST forms and NN 4.0+ browsers (1997)
another problem (1997)
Re:2nd WebCatalog2 Feature Request (1996)
This message couldn't reach the list! (1998)
Can't load tmpl files (1997)
[WebDNA] Is there a D.E. database record limit? (2014)
autosensing lanague selection (1997)
WC2f3 (1997)
Quit revisited (1997)
several .hdr files with one db file? (1999)