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:
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:
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)