Shipcost formula

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 59114
interpreted = N
texte = A while back Gary Krockover (thank you again!) sent me the following formula for the shipping element of the invoice: shipcost [showif [subtotal]<200][lookup db=shipcostings.db&lookInfield=destination&value=[destination]&returnfield=shipcostvalue][/showif][showif [subtotal]>199]0.00[/showif] This worked fine until I the parameters to include another field in the shipcostings.db called "shipoffer' for subtotals greater that $200.00. I have tried many combinations to get it working but for some reason I'm not succeeding. Help of any kind would be appreciated. Thanks again. JAMES MURTAGH ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Shipcost formula ( WJC Limited 2004)
  2. Re: Shipcost formula ( WJC Limited 2004)
  3. Re: Shipcost formula ( Gary Krockover 2004)
  4. Re: Shipcost formula ( Gary Krockover 2004)
  5. Re: Shipcost formula ( WJC Limited 2004)
  6. Re: Shipcost formula ( Gary Krockover 2004)
  7. Re: Shipcost formula ( WJC Limited 2004)
  8. Re: Shipcost formula ( Gary Krockover 2004)
  9. Re: Shipcost formula ( WJC Limited 2004)
  10. Re: Shipcost formula ( Gary Krockover 2004)
  11. Shipcost formula ( WJC Limited 2004)
  12. Re: Shipcost formula ( WJC Limited 2004)
  13. Re: Shipcost formula ( Gary Krockover 2004)
  14. Shipcost formula ( WJC Limited 2004)
  15. Re: ShipCost formula (for weight *and* quantities)? (PCS Technical Support 1998)
A while back Gary Krockover (thank you again!) sent me the following formula for the shipping element of the invoice: shipcost [showif [subtotal]<200][lookup db=shipcostings.db&lookInfield=destination&value=[destination]&returnfield=shipcostvalue][/showif][showif [subtotal]>199]0.00[/showif] This worked fine until I the parameters to include another field in the shipcostings.db called "shipoffer' for subtotals greater that $200.00. I have tried many combinations to get it working but for some reason I'm not succeeding. Help of any kind would be appreciated. Thanks again. JAMES MURTAGH ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ WJC Limited

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:

Color (1997) Autonumber (2003) [WebDNA] Feature requests - date format (2009) French characters in variables (2001) Banners (1997) Dynamic Pop up menu? (1997) Location of Webcat site in folder hierarchy (1997) Help name our technology! (1997) % (mod) was looping table rows (1999) shortening the cart (1998) Problems getting parameters passed into email. (1997) Re:Why did PCS send me this? (1999) WebMerchant 1.6 and SHTML (1997) Spiders and Bots (2000) I'm having trouble using [url][interpret][math] together inlookup (1997) Sendmail problem on UNIX (2000) Moment of Thanks (1997) emailer w/F2 (1997) grep question - removing spaces (2005) weird order problem in 4.5.1 (2004)