Re: Problem with Formulas.db

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 24986
interpreted = N
texte = [subTotal]>=100 PICK one....you cant have 2 criteria here. either greater than, less than or equal to. Than may helpBrian Boegershausen WebCatalog Programmer www.collegefever.com ----- Original Message ----- From: Karim Ardalan To: WebCatalog Talk Sent: Wednesday, December 01, 1999 5:15 PM Subject: Problem with Formulas.db > 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 ------------------------------------------------------------- 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)
[subTotal]>=100 PICK one....you cant have 2 criteria here. either greater than, less than or equal to. Than may helpBrian Boegershausen WebCatalog Programmer www.collegefever.com ----- Original Message ----- From: Karim Ardalan To: WebCatalog Talk Sent: Wednesday, December 01, 1999 5:15 PM Subject: Problem with formulas.db > 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 ------------------------------------------------------------- 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 Brian Boegershausen

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:

Separate SSL Server (1997) Orderfile context problem (1998) Clean Code: Rules for inserting keyboard returns? (1997) Hiding HTML and breaking the page (1997) Multiple catalog databases and showcart (1997) Web Catalog 2 demo (1997) [BULK] [WebDNA] [BULK] Mac OS X LION has no FastCGI (2011) cookies and case (2006) suggestion (1997) Code for Accessing E-mail Accounts (2005) search form problem.. (1997) Banners and sort of random display (1997) Interfacing WebMerchant to www.fedex.com (1997) ShowNext truncating passed variable?? (1997) Running _every_ page through WebCat ? (1997) Re:no [search] with NT (1997) Memorial Day Weekend (2003) search form problem.. (1997) Re:WebCatalog vidoes (was: Prices Dropped) (1998) Request for improvement... (2002)