Shipping [grandtotal] solution

This WebDNA talk-list message is from

1997

It keeps the original formatting. numero = 15220
interpreted = N
texte = Hey all,Janna and I here at Big MInd Media have gotten tons of awesome help from this list during the past weeks as we have been setting up at store at http://www.osmosis.com/. The store is up and (fingers crossed) running well so far. I thought I would pass along a fix I did which may come in handy for someone down the road...For those following Janna's shipping questions, you'll know that we had set up shipping based on dollar amount (ex., $1.00 to $20.00, add $4.95 for shipping, $20.00 to $40.00, add $5.95, etc.) by creating a shipping database using the roundup format:[lookup db=ship.db&lookInField=subtot&value=[format .0f][subtotal][/format]&returnField=shipping¬Found=10]This works for us. The only problem left was that [grandtotal], which is an internal formula (i.e., nothing we can change) was only adding subtotal and tax and did not know to look for the shipping as we had set it up. To solve this, I used the [math] context in place of [grandtotal] to create the formula[subtotal] + [taxtotal] + [shipping cost formula], which looks like this:[math][subTotal]+[taxTotal]+[lookup db=ship.db&lookInField=subtot&value=[format .0f][subtotal][/format]&returnField=shipping¬Found=10][/math]fyi, this did not work at first when I set it up as subtotal + shipping cost + taxtotal. I guess the formula needed to be at the end of the string. This solution has worked for us and I just thought I'd pass it along in case it comes up for anyone in need.Take care all, and thanks again,Peace,John--------------------------------------------------------------------------Currently featured award-winning websites developed by Big Mind Media formerly QECMedia):Body & Soul West Hollyhock Island Retreat Center Across Borders Productions The Miracle NunBun --------------------------------------------------------------------------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:

Shipping [grandtotal] solution (John Englander 1997)

Hey all,Janna and I here at Big MInd Media have gotten tons of awesome help from this list during the past weeks as we have been setting up at store at http://www.osmosis.com/. The store is up and (fingers crossed) running well so far. I thought I would pass along a fix I did which may come in handy for someone down the road...For those following Janna's shipping questions, you'll know that we had set up shipping based on dollar amount (ex., $1.00 to $20.00, add $4.95 for shipping, $20.00 to $40.00, add $5.95, etc.) by creating a shipping database using the roundup format:[lookup db=ship.db&lookInField=subtot&value=[format .0f][subtotal][/format]&returnField=shipping¬Found=10]This works for us. The only problem left was that [grandtotal], which is an internal formula (i.e., nothing we can change) was only adding subtotal and tax and did not know to look for the shipping as we had set it up. To solve this, I used the [math] context in place of [grandtotal] to create the formula[subtotal] + [taxtotal] + [shipping cost formula], which looks like this:[math][subTotal]+[taxTotal]+[lookup db=ship.db&lookInField=subtot&value=[format .0f][subtotal][/format]&returnField=shipping¬Found=10][/math]fyi, this did not work at first when I set it up as subtotal + shipping cost + taxtotal. I guess the formula needed to be at the end of the string. This solution has worked for us and I just thought I'd pass it along in case it comes up for anyone in need.Take care all, and thanks again,Peace,John--------------------------------------------------------------------------Currently featured award-winning websites developed by Big Mind Media formerly QECMedia):Body & Soul West Hollyhock Island Retreat Center Across Borders Productions The Miracle NunBun --------------------------------------------------------------------------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:

[WebDNA] Crashing Database (2011) WC 2.0 frames feature (1997) Using Plug-In while running 1.6.1 (1997) Maximum characters in header? (1999) More on the email templates (I like it) (1997) page redirect in webDNA (1997) tcpsend formatting issue ... (2004) [WebDNA] Finding duplicate records (2011) WebStar Secure on other machine (1997) Search inside Include (1998) WebCat2b12--[searchstring] bug (1997) Trapping Emailer Errors (2002) Random ads (1998) Sort Order on a page search (1997) videos.. yak..yak (1998) [OT] Happy Turkey Day! (2003) Emailer not working (1998) AppleScript does not work properly ... (2000) 4.5 on 10.4 (2006) [WebDNA] [switch] [case] only works with "=" comparisons.. true? (2009)