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:
E-mail Attachments (1997)
Mass deletion of records (2006)
HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997)
Non-Cart Files in Shopping Cart Folder (1997)
Re:quit command on NT (1997)
Download Question (1997)
Protect (1997)
[isfile] ? (1997)
ANother SHOWIF problem (1997)
Sorting Numbers (1997)
[lookup] speed sales pitch (2003)
WebCat2 - many [carts] on one template page? (1997)
Re:Searching for ALL / empty form field (1997)
Problem (1997)
Calendar using WebCatalog? (1997)
Y2k compliance (1998)
Location of Browser Info.txt file (1997)
Pull down menu for categories (2000)
WebCatalog for Postcards ? (1997)
Fwd: Problems with Webcatalog Plug-in (1997)