Shipping charges based on dollar level

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 15321
interpreted = N
texte = We are currently trying to implement a shipping charge based on subtotal.0.01-25.00 = 4.00 25.01 - 50.00 = 5.00 50.01 - 100.01 = 6.00 etc. etc.I am aware that by using the [lookup] tag the matching values have to be exact. The only problem with that is that there are way too many possibilities for the subtotal and the shipping db would be way too big.Does anyone know how to do a smaller db with the lookup finding the closest possible match? Or is there another solution?? regards, Associated Messages, from the most recent to the oldest:

    
  1. Re: Shipping charges based on dollar level (Ray Hatch 1997)
  2. Shipping charges based on dollar level (Updates 1997)
We are currently trying to implement a shipping charge based on subtotal.0.01-25.00 = 4.00 25.01 - 50.00 = 5.00 50.01 - 100.01 = 6.00 etc. etc.I am aware that by using the [lookup] tag the matching values have to be exact. The only problem with that is that there are way too many possibilities for the subtotal and the shipping db would be way too big.Does anyone know how to do a smaller db with the lookup finding the closest possible match? Or is there another solution?? regards, Updates

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:

Looking up two prices in database? (1997) Email problem (1998) Next X hits (1996) WebCatalog Technical Reference (1997) Problem with summ=T & [sum fieldname=] (2001) killing white space (1998) no global [username] or [password] displayed ... (1997) Associative lookup style? (1997) Applescript Hack (1996) Simple way to create unique SKU (1997) problems with 2 tags (1997) writing orders to a db (1997) OT ImageMagick and Thumbnails (2003) WebCat2 - [format thousands] (1997) WebCommerce: Folder organization ? (1997) Updating fields from different platforms (1998) denied access (1997) Not really WebCat - need HTML Grider (1997) Nav4 not specifying cart (1997) international time (1997)