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:

Last Record not recognized? (1999) Variables from a long text string (2000) NetSplat and WebCat2 (1997) emailer problem on OS X - unsent emails (2003) Counting LineItems (2000) Closing Databases (take 2) (1998) Showing once on a founditems (1997) Emailer (1999) [CART] (1997) WCS Newbie question (1997) PCS Frames (1997) Last Minute addition to WildWebCAT98... (1999) WebCatalog not recognizing ShoppingCarts folder (2000) Multi Colonns (1998) Trouble with formula.db + more explanation (1997) PCS Frames-Default page is solution! (1997) WebCat2final1 crashes (1997) Need formum software... (2003) Size limit for tmpl editor ? (1997) Problem 2: Prefs file... (1997)