Shipping Calculation Problem
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 15604
interpreted = N
texte = Last month, after much work (and assistance from this list), I set up a webcatalog store (hppt://www.bigmindmedia.com/osmosis). One obstacle that was resolved had to do with shipping. In order to calculate shipping based on total dollar amount (ex., $1 to $20 = $4.95 for shipping and handling, and so on), I set up a database called ship.db and used the formula:[format .2f][lookup db=ship.db&lookInField=subtot&value=[format .0f][subtotal][/format]&returnField=shipping¬Found=10][/format]This has worked great so far. Unfortunately, I have a new problem, which is that in this store, we are selling some holiday gift certificates which SHOULD NOT HAVE any shipping or handling charges. I'm hoping the way I set up shipping is somehow compatible with appropriating a zero dollar amount for certain items towards the shipping calculation, but I can't figure out in my head how to make this work. Any one have any ideas?Thanks,John EnglanderBig Mind Media--------------------------------------------------------------------------Check out John's Website and new CD, River Song, at his NOMA/Big Mind website:
Currently featured award-winning websites developed by Big Mind Media:Body & Soul West Hollyhock Island Retreat Center Osmosis Online --------------------------------------------------------------------------John Englander Big Mind Media 2814 12th Ave, SouthNashville, TN 37204615-297-7774 ext. 3, voice615-297-9652 fax
Associated Messages, from the most recent to the oldest:
Last month, after much work (and assistance from this list), I set up a webcatalog store (hppt://www.bigmindmedia.com/osmosis). One obstacle that was resolved had to do with shipping. In order to calculate shipping based on total dollar amount (ex., $1 to $20 = $4.95 for shipping and handling, and so on), I set up a database called ship.db and used the formula:[format .2f][lookup db=ship.db&lookInField=subtot&value=[format .0f][subtotal][/format]&returnField=shipping¬Found=10][/format]This has worked great so far. Unfortunately, I have a new problem, which is that in this store, we are selling some holiday gift certificates which SHOULD NOT HAVE any shipping or handling charges. I'm hoping the way I set up shipping is somehow compatible with appropriating a zero dollar amount for certain items towards the shipping calculation, but I can't figure out in my head how to make this work. Any one have any ideas?Thanks,John EnglanderBig Mind Media--------------------------------------------------------------------------Check out John's Website and new CD, River Song, at his NOMA/Big Mind website: Currently featured award-winning websites developed by Big Mind Media:Body & Soul West Hollyhock Island Retreat Center Osmosis Online --------------------------------------------------------------------------John Englander Big Mind Media 2814 12th Ave, SouthNashville, TN 37204615-297-7774 ext. 3, voice615-297-9652 fax
John Englander
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:
HTTP upload (2000)
Java and WebDNA (2002)
orderfile and setlineitems (1998)
HEADER AND FOOTER (1997)
Bug Report, maybe (1997)
[search] and [shownext] Problem (2000)
OR-searching (2000)
webcat- multiple selection in input field (1997)
Bug Report, maybe (1997)
Summing fields (1997)
RE: Redirect (1998)
I'm new be kind (1997)
[WebDNA] Bug in 6.2? (2009)
duplicate cart numbers (2002)
Decimal point in search.... (2004)
How to find 100 most recent additions. (1997)
WebCat2b15MacPlugin - [protect] (1997)
greater than or equal to (1997)
setting a cookie for the whole server (2004)
[WebDNA] Email Log.txt recommendations (2012)