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 Englander Big 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, South Nashville, TN 37204 615-297-7774 ext. 3, voice 615-297-9652 fax Associated Messages, from the most recent to the oldest:

    
  1. Re: Shipping Calculation Problem (Sandra L. Pitner 1997)
  2. Shipping Calculation Problem (John Englander 1997)
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 Englander Big 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, South Nashville, TN 37204 615-297-7774 ext. 3, voice 615-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:

restart needed???? (1997) WC2.0 Memory Requirements (1997) Searching for (field1 OR field2) AND field3 (2000) Nested Loops and SHOWIFs (1997) [WebDNA] WebDNA vs. php war ;-) (2010) [WC 2.1.30] Stack overflow. (2000) Re: (2000) Replacing the db file (2000) Forms Search Questions (1997) Problem with Shared POP script (2003) Pithy questions on webcommerce & siteedit (1997) [WebDNA] email stops sending (2008) random .inc files pulled and placed (2002) syntax question, not in online refernce (1997) [WebDNA] Serial numbers and pricing for WebDNA 7.0 (2011) WebCat2b15MacPlugin - [protect] (1997) possible, WebCat2.0 and checkboxes-restated (1997) Any idea why I am getting this error? (2001) unixODBC and WebCatalog (2001) F3 crashing server (1997)