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:
Help! WebCat2 bug (1997)
Progress !! WAS: Trouble with formula.db (1997)
Message Board (1998)
WC2.0 Memory Requirements (1997)
Almost a there but..bye bye NetCloak (1997)
Nutscrape Doesn't Render Right (2002)
WCS Newbie question (1997)
Error -108 (1997)
Suffix Mapping (1998)
WebCat2 several catalogs? (1997)
WebCat2 as a chat server? (1997)
authorize net (2001)
&fieldsdir=ra truely random?? (2000)
Re1000001: Setting up shop (1997)
international time (1997)
[WebDNA] TCPConnect Problem (2010)
[OT] Happy Turkey Day! (2003)
WebCat2b12plugin - [search] is broken ... not! (1997)
New WebDNA Example from Olin -- (1998)
in header include files? (1998)