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:
question: back button prevention (1997)
WebCat2b12--[searchstring] bug (1997)
Where's Cart Created ? (1997)
Extended [ConvertChars] (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Re[2]: (2000)
Protect (1997)
Database Options (1997)
emailer on Windows Beta 18 (1997)
CommandSecurity? (1997)
[SHOWIF] (1997)
Multi-Row Tables from a search. (1997)
How do you cause a new window to appear behind the current (1999)
Disappearing data [OT] (2002)
What if SSL server down? MAC (1997)
japanese characters (1997)
Quick ShowIf question (1997)
WCf2 and nested tags (1997)
underscore in variable name (2000)
Not really WebCat- (1997)