Re: Discounts
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 36549
interpreted = N
texte = on 6/21/01 1:52 PM, Nitai @ ComputerOil at nitai@computeroil.com so noted...> I have 3 discounts stored for each item in the products.db. > > Getting the discount out of the products.db is no problem within a lineitems > context. I do a lookup with quantity and get the desired discount...BUT... > > Let say I have a items and the customer buys 20 pieces. In the products.db > the discount for 20 pieces is stored with 10%. I get this discount out but I > also get the discount for 10 pieces which is 5%. How can I only get the > discount out for 20 pieces? > > Here is the code I have used so far: > > [if (([quantity]=5) | ([quantity]>5))] > [then] > You get 10% > [/then] > > [if (([quantity]=10) | ([quantity]>10))] > [then] > You get 15% > [/then] > > [if (([quantity]=20) | ([quantity]>20))] > You get 20% > [/then] > > [/if] > > [/if] > > [/if][math show=f]discount=0[/math] [showif [quantity]>4][math show=f]discount=10[/math][/showif] [showif [quantity]>9][math show=f]discount=15[/math][/showif] [showif [quantity]>19][math show=f]discount=20[/math][/showif]Discount is [discount]% Rob Marquardt Designer/Resident Wirehead Toast Design800 Washington Avenue North Minneapolis MN 55401 612.330.9863 v 612.321.9424 f www.toastdesign.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
on 6/21/01 1:52 PM, Nitai @ ComputerOil at nitai@computeroil.com so noted...> I have 3 discounts stored for each item in the products.db. > > Getting the discount out of the products.db is no problem within a lineitems > context. I do a lookup with quantity and get the desired discount...BUT... > > Let say I have a items and the customer buys 20 pieces. In the products.db > the discount for 20 pieces is stored with 10%. I get this discount out but I > also get the discount for 10 pieces which is 5%. How can I only get the > discount out for 20 pieces? > > Here is the code I have used so far: > > [if (([quantity]=5) | ([quantity]>5))] > [then] > You get 10% > [/then] > > [if (([quantity]=10) | ([quantity]>10))] > [then] > You get 15% > [/then] > > [if (([quantity]=20) | ([quantity]>20))] > You get 20% > [/then] > > [/if] > > [/if] > > [/if][math show=f]discount=0[/math] [showif [quantity]>4][math show=f]discount=10[/math][/showif] [showif [quantity]>9][math show=f]discount=15[/math][/showif] [showif [quantity]>19][math show=f]discount=20[/math][/showif]Discount is [discount]% Rob Marquardt Designer/Resident Wirehead Toast Design800 Washington Avenue North Minneapolis MN 55401 612.330.9863 v 612.321.9424 f www.toastdesign.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://search.smithmicro.com/
Rob Marquardt
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:
WebCat2b15MacPlugin - showing [math] (1997)
New index for docs (1997)
Reverse WHOIS (2003)
Dates - Search and Sorting (1999)
[WebDNA] copy some database fields into a new database (2016)
WebCatalog 2.0 b 15 mac (1997)
[WebDNA] Need some PHP help (2009)
WebCat and image maps (1997)
.html processing? (1998)
Include a big block of text (1997)
Re:Dashes and dots in credit card (1998)
What am I missing? (1998)
Initiating NewCart (1997)
template security preferences????? (1998)
Multiple catalog databases and showcart (1997)
RED QUESTION MARK (1999)
Encrypted links ... (2000)
More on [lookup] (1999)
Subtotal Not Calculated on Invoice.html (1998)
Mac v. NT (1998)