Re: shipping help

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 16365
interpreted = N
texte = >from to shipping >0.00 10 3.75 >10.01 25 4.75 >25.01 50 6.75 >50.01 100 9.75 >100.01 150 12.75 >150.01 200 15.75 > >The goal is to have S&H charges based upon the subtotal of the order. >For instance, if the subtotal is $15.00, the shipping charges would be >$4.75. To that end, I set up the following in my formulas.db: I think you might want to try a different shipping table structure.Try ordersize shipping 0 3.75 10.01 4.75 25.01 6.75 Then do a search for the purchase price less than the ordersize, sorted in descending order with a max=1. Good luck!Sandy Associated Messages, from the most recent to the oldest:

    
  1. Re: Shipping Help! (Pete at Work 1998)
  2. Re: Shipping Help! (Pete at Work 1998)
  3. Re: Shipping Help! (PCS Technical Support 1998)
  4. Shipping Help! (Pete at Work 1998)
  5. Re: shipping help (Sandra L. Pitner 1998)
  6. shipping help (Dennis J. Bonsall, Jr. 1998)
>from to shipping >0.00 10 3.75 >10.01 25 4.75 >25.01 50 6.75 >50.01 100 9.75 >100.01 150 12.75 >150.01 200 15.75 > >The goal is to have S&H charges based upon the subtotal of the order. >For instance, if the subtotal is $15.00, the shipping charges would be >$4.75. To that end, I set up the following in my formulas.db: I think you might want to try a different shipping table structure.Try ordersize shipping 0 3.75 10.01 4.75 25.01 6.75 Then do a search for the purchase price less than the ordersize, sorted in descending order with a max=1. Good luck!Sandy Sandra L. Pitner

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:

wrong input values? (1997) Date Formats (1997) lookup and two records? (1997) Webcatalog quitting (1997) WebCat & WebTen (1997) docs for WebCatalog2 (1997) WebCat2b12 CGI Mac - [shownext] problem (1997) Multiple prices (1997) restart needed???? (1997) WebDNA on Intel Mac? (2006) WC Database Format (1997) Append again (1999) HTML encoding in URLs (1997) Smart caching problems with 2.1b3? (1997) WebCat B13 Mac CGI -- Frames question (1997) It just Does't add up!!! (1997) Who owns the code? (2002) DataBaseHelper Flawed (1997) WebMerchant setup (1998) sendmail for email (was Netforms) (1998)