Re: ShipCosts database
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12829
interpreted = N
texte = Ooops. One problem, Grant. I *think* this is working fine, for one product at a time. (it's getting very late here on the East coast, so apologies in advance if I've missed something :-0 )But....what I need the formula to do is add all the weights, *then* look up the corresponding cost! I think what I need is a new variable, something like SumWeights, then use your formula to lookup the cost for NextDay or Ground by SumWeights. I'll give it a shot tomorrow...1'st time to assign a variable (I think I can do that, right?)Thanks,Dale dstokdyk@dvs.mv.com Grant Hulbert wrote: > > >To address weight and shipMethod....should I set up a ShipCosts.db > >similar to below, then use Search with And to look up the correct > >price...something like: > > I think a simpler database would be > > Weight Ground NextDay > 1 3.00 7.00 > 2 4.00 7.00 > > That way you can do a simple lookup for the cost: > > [lookup db=shipcosts.db&lookInField=weight&value=[weight]&returnField=[shipVia]] > > The only 'trick' here that some people may not think of is that you can use a variable [shipVia] as the name of which field to return from the lookup. Cool, huh? >
Associated Messages, from the most recent to the oldest:
Ooops. One problem, Grant. I *think* this is working fine, for one product at a time. (it's getting very late here on the East coast, so apologies in advance if I've missed something :-0 )But....what I need the formula to do is add all the weights, *then* look up the corresponding cost! I think what I need is a new variable, something like SumWeights, then use your formula to lookup the cost for NextDay or Ground by SumWeights. I'll give it a shot tomorrow...1'st time to assign a variable (I think I can do that, right?)Thanks,Dale dstokdyk@dvs.mv.com Grant Hulbert wrote: > > >To address weight and shipMethod....should I set up a ShipCosts.db > >similar to below, then use Search with And to look up the correct > >price...something like: > > I think a simpler database would be > > Weight Ground NextDay > 1 3.00 7.00 > 2 4.00 7.00 > > That way you can do a simple lookup for the cost: > > [lookup db=shipcosts.db&lookInField=weight&value=[weight]&returnField=[shipVia]] > > The only 'trick' here that some people may not think of is that you can use a variable [shipVia] as the name of which field to return from the lookup. Cool, huh? >
Dale Stokdyk
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:
WebCommerce: Folder organization ? (1997)
Date sorting (2004)
resorting found set (2005)
Updating emailer (server) (2000)
can WC render sites out? (1997)
Lost Password? (2002)
why is authenticate screwing with me today (2002)
removelineitems (2000)
New WebDNA Example from Olin -- (1998)
process SSI (1998)
Frames and WebCat (1997)
Showif date > other date (2004)
Setting up shop (1997)
Setting up the server (1997)
ShowNext Command (1997)
Multiple Ad databases? (1997)
PCS Frames-Default page is solution! (1997)
[WebDNA] [OT] WSC Forum (2009)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
Generating Report Totals (1997)