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:
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)