Re: Problem with Formulas.db
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 24986
interpreted = N
texte = [subTotal]>=100PICK one....you cant have 2 criteria here. either greater than, less than orequal to.Than may helpBrian BoegershausenWebCatalog Programmerwww.collegefever.com----- Original Message -----From: Karim Ardalan
To: WebCatalog Talk Sent: Wednesday, December 01, 1999 5:15 PMSubject: 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 MessagingServer.> 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:
[subTotal]>=100PICK one....you cant have 2 criteria here. either greater than, less than orequal to.Than may helpBrian BoegershausenWebCatalog Programmerwww.collegefever.com----- Original Message -----From: Karim Ardalan To: WebCatalog Talk Sent: Wednesday, December 01, 1999 5:15 PMSubject: 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 MessagingServer.> 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)