What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

Formulas.db / Quantity Discount problem

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 16767
interpreted = N
texte = 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 _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/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 (PCS Technical Support 1998)
  3. Re:Formulas.db / Quantity Discount problem (Paul Uttermohlen 1998)
  4. Re:Formulas.db / Quantity Discount problem (Jay Van Vark 1998)
  5. Formulas.db / Quantity Discount problem (Paul Uttermohlen 1998)
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 _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/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:

related data (2003) javascript popup (2005) Errata: WCS Newbie question (1997) WebCat for Unix?? (1997) quotation marks needed? (2000) Great product and great job ! (1997) LookUp Tag (1997) Interfacing WebMerchant to www.fedex.com (1997) [removehtml]? (2000) WebCatalog2 Feature Feedback (1996) SiteGuard Use Question (1997) Pgp&emailer (1997) $Quit, $CloseDatabase corrections (1997) WebCatalog 2.0 b 15 mac (1997) For those of you not on the WebCatalog Beta... (1997) Serving images from databases (1998) multiple databases (1997) Highlighting words found in a keyword search (2003) Configuring E-mail (1997) Associative lookup style? + bit more (1997)