Re: Shipcost formula
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 59120
interpreted = N
texte = GaryI returned the formula to the original one to keep things working.NameFormulaprice[lookup db=items.db&lookInField=sku&value=[sku]&returnField=price]taxrate[lookup db=taxrates.db&lookinfield=country&value=[destination]&returnfield=taxrate¬Found=0.00]shipcost [showif [subtotal]<200][lookup db=shipcostings.db&lookInfield=destination&value=[destination]&returnfield=shipcostvalue][/showif][showif [subtotal]>199]0.00[/showif]unitshipcost0.00The following was the formula I triedshipcost [showif [subtotal]<200][lookup db=shipcostings.db&lookInfield=destination&value=[destination]&returnfield=shipcostvalue][/showif][showif [subtotal]>199][lookup db=shipcostings.db&lookInfield=destination&value=[destination]&returnfield=offership][/showif]I'm leaving work now (6.15pm) but I'll be back on line in half an hour.JAMES-------------------------------------------------------------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 Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
GaryI returned the formula to the original one to keep things working.NameFormulaprice[lookup db=items.db&lookInField=sku&value=[sku]&returnField=price]taxrate[lookup db=taxrates.db&lookinfield=country&value=[destination]&returnfield=taxrate¬Found=0.00]shipcost [showif [subtotal]<200][lookup db=shipcostings.db&lookInfield=destination&value=[destination]&returnfield=shipcostvalue][/showif][showif [subtotal]>199]0.00[/showif]unitshipcost0.00The following was the formula I triedshipcost [showif [subtotal]<200][lookup db=shipcostings.db&lookInfield=destination&value=[destination]&returnfield=shipcostvalue][/showif][showif [subtotal]>199][lookup db=shipcostings.db&lookInfield=destination&value=[destination]&returnfield=offership][/showif]I'm leaving work now (6.15pm) but I'll be back on line in half an hour.JAMES-------------------------------------------------------------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 Web Archive of this list is at: http://webdna.smithmicro.com/
WJC Limited
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:
Sorting via date (2002)
WebCatalog can't find database (1997)
Version f1 status (1997)
unable to launch acgi in WebCat (1997)
Country & Ship-to address & other fields ? (1997)
Help! WebCat2 bug (1997)
[WebDNA] obituary service (2009)
Date Time Oddness (1999)
politeness (was searches with dash...) Please Read (2000)
Not really WebCat (1997)
Online reference (1997)
Searching multiple fields (1997)
Re:Realtime Transaction Processing (1999)
Bug in Mac webcatalog3_0_5b11 (1999)
[OT] Communigate List (2003)
OT-Load balance (2004)
I'm new be kind (1997)
Still Stumped on ShowNext...HELP! (1997)
formulas.db (1999)
[REQ] Improved SQL context (2000)