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:

    
  1. Re:Formulas.db / Quantity Discount problem (PCS Technical Support 1998)
  2. Re:Formulas.db / Quantity Discount problem (Paul Uttermohlen 1998)
  3. Re:Formulas.db / Quantity Discount problem (Jay Van Vark 1998)
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)