Re: creating a ShipCosts database
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12807
interpreted = N
texte = >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 beWeight Ground NextDay 1 3.00 7.00 2 4.00 7.00That 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?Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
>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 beWeight Ground NextDay 1 3.00 7.00 2 4.00 7.00That 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?Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Grant Hulbert
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:
[Solved? - with code] catching WebDNA error messages (2003)
how to post without certain data appearing in the html source (2001)
UN-WANTED character conversion (1999)
suffix mapping, use of cache, etc. (1997)
Emailer (WebCat2) (1997)
Help Encrypt/Decrypt eMail (2003)
Ok here is a question? (1997)
Permissions Ignored - PLEASE HELP (2003)
member pages (2000)
WebCatalog 2.0 b 15 mac (1997)
Problems searching from a FORM (1997)
SM's Tech Help (or lack of) (2000)
SiteEdit NewFile.html ? (1997)
External Images (1998)
I am sorry for always being such an a## (2004)
Roundup function? (1997)
RE: [WebDNA] special chars (2009)
Mailer Problems (1999)
Max Record length restated as maybe bug (1997)
Webcatalog and foreign languages (1998)