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:

WebCatalog f2 Installation (1997) [delete] problem (1997) Adding Shipping Fields (1999) DataBaseHelper Flawed (1997) Calculating multiple shipping... (1997) Design Help Needed (1998) Enhancement Request for WebCatalog-NT (1996) The code, one more time. (2003) NT Manual (1997) [WebDNA] Test - Getting double messages??? (2008) HELP WITH DATES (1997) Bug Report, maybe (1997) Auto entering Friday's date in a field (2002) SSL and reg web* (1997) Re:2nd WebCatalog2 Feature Request (1996) Viewing old carts (was FEW QUESTIONS) (1997) Converting back to numerical date (2003) WebCat/CyberStudio Compatibility (1998) WebCat2b12 - nesting [tags] (1997) Proper file locations (1997)