shipcost and Formulas.db
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 26840
interpreted = N
texte = After seeing a recent posting with a similar situation, I'm back to trying to use Formulas.db to solve my shipping situation, which is:* use a flat rate depending on user-selected shipping method (stored in [shipvia]) * charge that flat rate for one shippable item * charge $2 more per additional shippable item * charge $0 for any downloadables * therefore, if all ordered items are DLable only, shipcost should be $0 instead of whatever was selected as a shipping method.Here is my Formulas.db. I apologize for bad breaks: Yahoo mail really stinks in that regard... Name Formula shipCost [math show=f]temptotship=[lineitems][unitShipCost]+[/lineitems]0[/math][math show=f]baserate=[lookup db=admin/shippers.db&lookinfield=SHR_ID&value=[shipVia]&returnfield=SHR_AMT]-2[/math][hideif temptotship=0][baserate][/hideif][showif temptotship=0]0[/showif]What happens is that the baserate is being charged, even if all the lineitems are downloadable and thus have unitshipcost of 0.So I'm still having a problem zeroing out shipcost. What am I doing wrong or leaving out? Thanks for any guidance.__________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com------------------------------------------------------------- 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:
After seeing a recent posting with a similar situation, I'm back to trying to use formulas.db to solve my shipping situation, which is:* use a flat rate depending on user-selected shipping method (stored in [shipvia]) * charge that flat rate for one shippable item * charge $2 more per additional shippable item * charge $0 for any downloadables * therefore, if all ordered items are DLable only, shipcost should be $0 instead of whatever was selected as a shipping method.Here is my formulas.db. I apologize for bad breaks: Yahoo mail really stinks in that regard... Name Formula shipCost [math show=f]temptotship=[lineitems][unitShipCost]+[/lineitems]0[/math][math show=f]baserate=[lookup db=admin/shippers.db&lookinfield=SHR_ID&value=[shipVia]&returnfield=SHR_AMT]-2[/math][hideif temptotship=0][baserate][/hideif][showif temptotship=0]0[/showif]What happens is that the baserate is being charged, even if all the lineitems are downloadable and thus have unitshipcost of 0.So I'm still having a problem zeroing out shipcost. What am I doing wrong or leaving out? Thanks for any guidance.__________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com------------------------------------------------------------- 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
Chris Vargas
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:
getting images' width/height (1998)
Exists? (1997)
authorizenet and netscape (2002)
upgrading 5.0 --> 5.1g (2004)
authenticate and password (1998)
RE: Include (1998)
[ShowNext] feature in 2.0 (1997)
Linked lists and Recursive searching (2003)
Just Testing (1997)
Signal Raised error (1997)
Emailer error 571 (1998)
PROBLEMS WITH PROTECT TAG (2004)
Group Updates (1998)
[browsername] not working? (1997)
Force a search at the default.tmpl page? (1997)
Fwd: virtual domain and [listfile] paths and aliases (1998)
Signal Raised Error (1997)
WebCat2b12 forgets serial # (1997)
[Solved? - with code] catching WebDNA error messages (2003)
Locking up with WebCatalog... (1997)