Re: Formulas.db
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 40009
interpreted = N
texte = >Hello, Our company has somewhat complex discounting for its products depending on sku, quantity etc... It's the etc part that bothers me, but here's what I did long ago for quantity discounts.price [showif [quantity]<3][lookup db=My.db&lookInField=sku&value=[sku]&returnField=price1to2][/showif][hideif [quantity]>5][showif [quantity]>2][lookup db=My.db&lookInField=sku&value=[sku]&returnField=price3to5][/showif][/hideif][hideif [quantity]>11][showif [quantity]>5][lookup db=My.db&lookInField=sku&value=[sku]&returnField=price6to11][/showif][/hideif][showif [quantity]=12][lookup db=My.db&lookInField=sku&value=[sku]&returnField=price12][/showif][showif [quantity]>12][lookup db=My.db&lookInField=sku&value=[sku]&returnField=priceover12][/showif]-------------------------------------------------------------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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>Hello, Our company has somewhat complex discounting for its products depending on sku, quantity etc... It's the etc part that bothers me, but here's what I did long ago for quantity discounts.price [showif [quantity]<3][lookup db=My.db&lookInField=sku&value=[sku]&returnField=price1to2][/showif][hideif [quantity]>5][showif [quantity]>2][lookup db=My.db&lookInField=sku&value=[sku]&returnField=price3to5][/showif][/hideif][hideif [quantity]>11][showif [quantity]>5][lookup db=My.db&lookInField=sku&value=[sku]&returnField=price6to11][/showif][/hideif][showif [quantity]=12][lookup db=My.db&lookInField=sku&value=[sku]&returnField=price12][/showif][showif [quantity]>12][lookup db=My.db&lookInField=sku&value=[sku]&returnField=priceover12][/showif]-------------------------------------------------------------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://search.smithmicro.com/
Glenn Busbin
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:
StandardConversions.db (1998)
WebDNA Quick Reference (Reserved Words) (2000)
sorted cart? (1998)
WebCat2b13MacPlugIn - More limits on [include] (1997)
RAM variables (1997)
HELLO (2000)
AD Error Msg (1997)
Summary search -- speed (1997)
Price override - solved (2004)
CART question (2004)
WebCat2b12 CGI Mac -- Problems propagating the cart through frames...still (1997)
Why no EMailFolder? (2001)
Fwd: Protect Tag and Groups (1998)
Bug alert! (1997)
WebCat2: Items xx to xx shown, etc. (1997)
Country & Ship-to address & other fields ? (1997)
Major bug report on rootbeer (1997)
Sort Order on a page search (1997)
shownext & math (1997)
[WebDNA] sandboxes etc (2009)