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:
Do triggers work on Macs? (2000)
Explorer 3.0/ Access Denied! (1997)
pc (1997)
database freeze (1997)
Summing a field full of numbers ... (1997)
[WebDNA] No [interpret] on unix-Macintosh OSX FastCGI version 7.0.594 (2012)
Force a search at the default.tmpl page? (1997)
notification solutions (1997)
[OT] Google Info (2004)
RE: Missing contexts on NT (1997)
Decimal point in search.... (2004)
WebCatalog can't find database (1997)
Help name our technology! (1997)
[OT] (waaaay OT) further off topic than before (2004)
Fun with dates (1997)
[Price] (1997)
RE: textA and Title? (1997)
[ShowIf] if the varieable exists (1998)
Using Cookie for client specific info? (1997)
Null Characters (2005)