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 standard0 9.95 7.60 4.805 9.95 7.60 5.9010 19.95 13.95 9.9530 24.95 17.95 12.9550 34.95 24.95 17.95100 59.95 44.95 32.95150 89.95 64.95 45.95300 119.95 84.95 59.9599999 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 gettingshipVia and item quantities from the shopping cart page. Since I don't yethave this information until I get to the invoice page, how do I properlycalculate total weight for each item quantity, then perform the lookup, aftergetting shipVia? Associated Messages, from the most recent to the oldest:

Re: weight based shipping cost questions (Pat McCormick 1997) Re: weight based shipping cost questions (Pat McCormick 1997) weight based shipping cost questions (Pat McCormick 1997)

My shipping cost database looks like this:weight nextday twoday standard0 9.95 7.60 4.805 9.95 7.60 5.9010 19.95 13.95 9.9530 24.95 17.95 12.9550 34.95 24.95 17.95100 59.95 44.95 32.95150 89.95 64.95 45.95300 119.95 84.95 59.9599999 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 gettingshipVia and item quantities from the shopping cart page. Since I don't yethave this information until I get to the invoice page, how do I properlycalculate total weight for each item quantity, then perform the lookup, aftergetting 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:

Adding headers to email (1997) PCS Frames (1997) Trouble with formula.db (1997) Extended [ConvertChars] (1997) Append again (1999) WebCat2b12--[searchstring] bug (1997) Forms Search Questions (1997) TCPConnect (1998) [writefile] ugliness continued (2001) Help! WebCat2 bug (1997) RequiredFields template (1997) Possible Bug in 2.0b15.acgi (1997) assigning a id no. (2000) system crashes, event log (1997) Modtime bug? (2002) WebDNA 5.0 freeBSD?!!? (2003) Security Question (1997) Just Testing (1997) multi-paragraph fields (1997) WebCat2b15MacPlugin - showing [math] (1997)