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:
Date comparison using showif (2003)
sendmail spaces (1997)
New WebDNA Solutions ... (1997)
emailer (1997)
Mozilla/4. and Browser Info.txt (1997)
WebCat2: Items xx to xx shown, etc. (1997)
Setting up shop (1997)
Searching help needed (1998)
default value from Lookup (was Grant, please help me) (1997)
SET and C-SET (1998)
purchase plugin (1996)
encryption madness (2004)
WebTen Memory Error with Plug-In (1998)
Re:Help name our technology! (1997)
Fwd: Emailer & IMail List Server (1998)
possible, WebCat2.0 and checkboxes-restated (1997)
WC1.6 to WC2 date formatting (1997)
Handy Browser Counter Tip (1997)
orderfile and setlineitems (1998)
Forcing a NEWCART (1997)