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:

Introduction/Tutorial/QuickStart (1997) searchable list archive (1997) Stop the madness. (1997) PSC recommends what date format yr 2000??? (1997) Multiple cart additions (1997) Entry pages (was: WebCatalog MAJOR drawback) (1998) Issue with plug-in Webcat, webstar 4.x, SSL and IE when using the backbuttom (2000) cookies and [returnraw] (1997) More on the email templates (1997) Forcing Paragraph Breaks on Results (1998) How to Display text in empty fields (1997) WebSTAR 2.1 freezes my Mac (1997) oops private message leaked into talk list (1997) MOOOOOO (2000) Ranking search results (2002) [sql] problems in WebCat 4.0 (2000) WebCatalog can't find database (1997) Webcat listserver - WAS - webcat method for waitingspecific amount of time? (2000) Browser Reloads and AddlineItem (1997) WC2b15 - [HTMLx]...[/HTMLx] problems (1997)