Problem with Formulas.db

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 24984
interpreted = N
texte = Hi, I am having problems with a formula. This is what I have in my formulas.db file for 'ShipCost':shipCost[Showif [ShipVia]=DHL2DAY][math]14+([lineitems][quantity]*[lookup db=Items.db&lookInField=SKU&value=[SKU]&returnField=weight¬Found=1]+[/lin eitems]0)*1.45[/math][/Showif][Showif [ShipVia]=UPSGROUND][Showif [subTotal]>=100]0.00[/Showif][Showif [subTotal]<100]5.95[/Showif][/Showif]But whenever I choose UPSGROUND it uses the 5.95 charge no matter what the subtotal is. Can someone see what I might be doing wrong?Thanks, Karim Ardalan MIS, Inc. ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Associated Messages, from the most recent to the oldest:

    
  1. Re: Problem with Formulas.db (Brian Boegershausen 1999)
  2. Problem with Formulas.db (Karim Ardalan 1999)
  3. Re: Problem with Formulas.db (Mike Heininger 1998)
  4. Re: Problem with Formulas.db (Mike Heininger 1998)
  5. Re: Problem with Formulas.db (Kenneth Grome 1998)
  6. Re: Problem with Formulas.db (PCS Technical Support 1998)
  7. Re: Problem with Formulas.db (Mícheál O Sé 1998)
  8. Problem with Formulas.db (Mike Heininger 1998)
Hi, I am having problems with a formula. This is what I have in my formulas.db file for 'ShipCost':shipCost[Showif [ShipVia]=DHL2DAY][math]14+([lineitems][quantity]*[lookup db=Items.db&lookInField=SKU&value=[SKU]&returnField=weight¬Found=1]+[/lin eitems]0)*1.45[/math][/Showif][Showif [ShipVia]=UPSGROUND][Showif [subTotal]>=100]0.00[/Showif][Showif [subTotal]<100]5.95[/Showif][/Showif]But whenever I choose UPSGROUND it uses the 5.95 charge no matter what the subtotal is. Can someone see what I might be doing wrong?Thanks, Karim Ardalan MIS, Inc. ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Karim Ardalan

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:

Emailer setup (1997) why is this line in GeneralStore? (1998) Using [Showif] tag. Mac (1997) Extended [ConvertChars] (1997) why .HTML pages no processing? (2000) Number searching/formats (1998) Retaining data (2003) process SSI (1998) RE: WebCatalog2 for NT Beta Request (1997) WebCatalog can't find database (1997) Multiply prices (1997) Cancel Subscription (1996) AutoCommit Preference? (1998) [include ...] behavior (1997) Snake Bites (1997) math a various prices (1997) Simultaneous Users (1999) Problems passing [SKU] with $Replace in 2.0 (1997) [include] and not found (2005) Code BabelFish (was: I've been thinking) (2002)