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:
Append command (2000)
Reversing [ipaddress] normalization (1998)
PCS Frames (1997)
Web Merchant process after credit card clears (1998)
[append] and SSL (1997)
frames & carts (1997)
[WebDNA] HTTP Streaming - POSSIBLE! (2010)
Hello??? (1997)
Shell context. (2002)
[date] tag not working on mac 4.0.1 (2000)
Setting up WebCatalog with Retail Pro data (1996)
P3P and IE 6 (2004)
Sending mail (was forms and variables) (1998)
Next X hits (1996)
WebCat2 Append problem (B14Macacgi) (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
sort problems....bug or brain fart? (1997)
Emailer help....! (1997)
Hiding HTML and breaking the page (1997)
Emailer help....! (1997)