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.dbfile for 'ShipCost':shipCost
[Showif[ShipVia]=DHL2DAY][math]14+([lineitems][quantity]*[lookupdb=Items.db&lookInField=SKU&value=[SKU]&returnField=weight¬Found=1]+[/lineitems]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 thesubtotal is. Can someone see what I might be doing wrong?Thanks,Karim ArdalanMIS, 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:
Hi,I am having problems with a formula. This is what I have in my formulas.dbfile for 'ShipCost':shipCost[Showif[ShipVia]=DHL2DAY][math]14+([lineitems][quantity]*[lookupdb=Items.db&lookInField=SKU&value=[SKU]&returnField=weight¬Found=1]+[/lineitems]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 thesubtotal is. Can someone see what I might be doing wrong?Thanks,Karim ArdalanMIS, 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)