Re: ShippingCosts
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19060
interpreted = N
texte = Ken,The revised lookup doesn't seem to work any better; it still returns 0.BTW, the lookup is[format .2f][lookupdb=formulas.db&value=ShipCost&lookinfield=Name&returnfield=Formula¬found=None][/format]I'm fairly new with [lookup]s and haven't messed with them. Does this lookright?Thanks,Bill>>For some reason, when I try to call the ShipCost from the formulas.db it>>doesn't lookup correctly.>>>>The line from the formulas.db is:>>>>ShipCost [Math]5[ShowIf [SubTotal]>25]-5[/ShowIf][/Math]>>>>So in the final checkout, I do a simple [format .2f][ShipCost][/format] and>>no matter what it shows up as 0.00. BTW, the above trick is from the WebCat>>Archives and seemed to work for the gent that used it, but I must be>>missing something.>>1- Is the lookup written properly?>2- Does this ShipCost formula work? ...>>[Math]0[ShowIf [SubTotal]<25]+5[/ShowIf][/Math]>>Sincerely,>Ken Grome>808-737-6499>WebDNA Solutions>mailto:ken@webdna.net>http://www.webdna.net--Bill Heissenbuttel PageHouse, Inc.bill@pagehouseinc.com Internet Presence Providerhttp://www.pagehouseinc.com (509) 892-1973
Associated Messages, from the most recent to the oldest:
Ken,The revised lookup doesn't seem to work any better; it still returns 0.BTW, the lookup is[format .2f][lookupdb=
formulas.db&value=ShipCost&lookinfield=Name&returnfield=Formula¬found=None][/format]I'm fairly new with
[lookup]s and haven't messed with them. Does this lookright?Thanks,Bill>>For some reason, when I try to call the ShipCost from the
formulas.db it>>doesn't lookup correctly.>>>>The line from the
formulas.db is:>>>>ShipCost
[math]5[ShowIf [SubTotal]>25]-5[/ShowIf][/Math]>>>>So in the final checkout, I do a simple [format .2f][ShipCost][/format] and>>no matter what it shows up as 0.00. BTW, the above trick is from the WebCat>>Archives and seemed to work for the gent that used it, but I must be>>missing something.>>1- Is the lookup written properly?>2- Does this ShipCost formula work? ...>>
[math]0[ShowIf [SubTotal]<25]+5[/ShowIf][/Math]>>Sincerely,>Ken Grome>808-737-6499>WebDNA Solutions>mailto:ken@webdna.net>http://www.webdna.net--Bill Heissenbuttel PageHouse, Inc.bill@pagehouseinc.com Internet Presence Providerhttp://www.pagehouseinc.com (509) 892-1973
Bill Heissenbuttel
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:
Shhh... (2006)
Credit Card Number checking (1997)
[WebDNA] Ubuntu 14.04 & WebDNA 8.2 (html not rendering) (2017)
WC2.0 Memory Requirements (1997)
Adobe Form Data Format (FDF) from Webcat? (2000)
Repeating Fields (1997)
authorizenet (2002)
Need help with emailer- 2 issues (1997)
Announcing general availabilty of WebDNA 4.5 release (2002)
Add to Cart & List of Products (1997)
[WebDNA] Scripts directory - IIS 5 and WebDNA 6.2 (2011)
Secure server question (1997)
Sorry WebCatalog Server Not Running (2002)
WebCat2b15MacPlugin - showing [math] (1997)
PIXO (1997)
Deleting Orders (1997)
Plugin or CGI or both (1997)
More questions about serial number dishing (1997)
Repost: Upload file limits (2000)
WebCatalog2 Feature Feedback (1996)