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:
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)