Re: creating a ShipCosts database
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12815
interpreted = N
texte = Grant, very cool indeed! I'll get it done today!!!Looking ahead...what I'd *really* like to end up with is the ability tobreak out Ground shippping charges by ZipCode zones (using the firstthree digits input by shoppers) and weight. For example, zip codes beginning with 004-005 would fall in Zone 3.Then, for each zone, charges would be determined by weight. *Now* we're talking about more than one database to determineShipCosts...right?DaleGrant 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:
Grant, very cool indeed! I'll get it done today!!!Looking ahead...what I'd *really* like to end up with is the ability tobreak out Ground shippping charges by ZipCode zones (using the firstthree digits input by shoppers) and weight. For example, zip codes beginning with 004-005 would fall in Zone 3.Then, for each zone, charges would be determined by weight. *Now* we're talking about more than one database to determineShipCosts...right?DaleGrant 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:
Plugin or CGI or both (1997)
[WebDNA] New Mountain Lion OSX Server (2013)
remote install on RH9 (2004)
So what ya working on? (or have you completed?) (2004)
About the + sign (2002)
Extended [ConvertChars] (1997)
[WebDNA] Authentication (2009)
relogin same user? (1998)
# fields limited? (1997)
Error Lob.db records error message not name (1997)
OBDC Support (1997)
Just Testing (1997)
[WebDNA] Emailer Issue (2009)
Formatting dates stored in db (2003)
[dos] command and [math] (1998)
WebCat b13 CGI -shownext- (1997)
I'm new be kind (1997)
FAX orders (1996)
quantity minimum problem (1997)
Calculating Age from DB fields (2003)