Re: weight based shipping cost questions

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 15703
interpreted = N
texte = My shipping cost database looks like this:weight nextday twoday standard 0 9.95 7.60 4.80 5 9.95 7.60 5.90 10 19.95 13.95 9.95 30 24.95 17.95 12.95 50 34.95 24.95 17.95 100 59.95 44.95 32.95 150 89.95 64.95 45.95 300 119.95 84.95 59.95 99999 139.95 104.95 63.95I can do a search nested in a lookup like[lookup db=ship.db&value=[search db=ship.db&geweightdata=[itemweight]&weightsort=1&weighttype=num&weightsdir=as&max=1] [founditems] [weight] [/founditems] [/search]&lookinfield=weight&returnfield=[shipVia]]shere shipVia is form selected from nextday, twoday, or standard.The problem is that I know the individual item weight, but I am getting shipVia and item quantities from the shopping cart page. Since I don't yet have this information until I get to the invoice page, how do I properly calculate total weight for each item quantity, then perform the lookup, after getting shipVia? Associated Messages, from the most recent to the oldest:

    
  1. Re: weight based shipping cost questions (Pat McCormick 1997)
  2. Re: weight based shipping cost questions (Pat McCormick 1997)
  3. weight based shipping cost questions (Pat McCormick 1997)
My shipping cost database looks like this:weight nextday twoday standard 0 9.95 7.60 4.80 5 9.95 7.60 5.90 10 19.95 13.95 9.95 30 24.95 17.95 12.95 50 34.95 24.95 17.95 100 59.95 44.95 32.95 150 89.95 64.95 45.95 300 119.95 84.95 59.95 99999 139.95 104.95 63.95I can do a search nested in a lookup like[lookup db=ship.db&value=[search db=ship.db&geweightdata=[itemweight]&weightsort=1&weighttype=num&weightsdir=as&max=1] [founditems] [weight] [/founditems] [/search]&lookinfield=weight&returnfield=[shipVia]]shere shipVia is form selected from nextday, twoday, or standard.The problem is that I know the individual item weight, but I am getting shipVia and item quantities from the shopping cart page. Since I don't yet have this information until I get to the invoice page, how do I properly calculate total weight for each item quantity, then perform the lookup, after getting shipVia? Pat McCormick

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:

Cannot calculate prices (1997) Using Cookie for client specific info? (1997) WebCatalog [FoundItems] Problem - LONG - (1997) Mail Server Needed. (1998) Re:no [search] with NT (1997) [WebDNA] Crashing Database (2011) WCS Newbie question (1997) [isfile] ? (1997) Cookie Question (1999) advise!! (2001) problems with 2 tags (1997) Banners (1997) [WebDNA] php/mySQL version of WebDNA Speed Test? (2009) Separate SSL Server (1997) Ok here is a question? (1997) [WebDNA] Generating Excel File Via WebDNA (2010) Sorting by date (1997) forced timeout? (1998) [WebDNA] [thisurlplusget] not working (2012) indexing dates (1998)