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:
f2 download problems (1997)
Windows-based Code Editor (2002)
Pass a form (2003)
Digital Postcards (1999)
why .HTML pages no processing? (2000)
Still trying to email... (1998)
Uh...can someone help me out with the b10? (1997)
Counting records (2000)
trouble updating records in database (1998)
Re1000002: Setting up shop (1997)
PSC recommends what date format yr 2000??? (1997)
LOOP and IF statements (1997)
Rendering out a page (1997)
Feature Request: [moverecord] (2003)
RE: Is there a 'does not contain' comparison? (1999)
Requiring that certain fields be completed (1997)
WC2b15 File Corruption (1997)
[WriteFile] problems (1997)
Re:no template caching (1997)
setting line item numbers (1998)