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 to break out Ground shippping charges by ZipCode zones (using the first three 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 determine ShipCosts...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:

    
  1. Re: creating a ShipCosts database (grichter@panavise.com (Gary Richter) 1997)
  2. Re: creating a ShipCosts database (Grant Hulbert 1997)
  3. Re: creating a ShipCosts database (Dale Stokdyk 1997)
  4. Re: creating a ShipCosts database (Grant Hulbert 1997)
  5. creating a ShipCosts database (Dale Stokdyk 1997)
Grant, very cool indeed! I'll get it done today!!!Looking ahead...what I'd *really* like to end up with is the ability to break out Ground shippping charges by ZipCode zones (using the first three 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 determine ShipCosts...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)