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:
Strange intermittent WebDNA problems (2008)
searching twice on same field (1998)
A link and two command (1998)
Country & Ship-to address & other fields ? (1997)
Creating folders and deleting files (1997)
IBM DB2 (2000)
search context w shownext works! (1997)
Problem displaying search result (1997)
Sendmail truncation in Eudora Clients (1998)
READFILE command? (1998)
Sku numbers (1997)
Need help... (1997)
expired beta (1997)
bug? template caching and apache transfer byte log (1999)
Secure server question (1997)
WEBCAT HIERARCHY (1999)
New public beta available (1997)
WebCat cannot handle compatible search parameters? (1997)
WebCat2b15MacPlugin - showing [math] (1997)
why .HTML pages no processing? (2000)