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:
[format xs] freeze (1997)
F3 crashing server (1997)
Replace Statement (1997)
Message Board (1998)
Summing a field full of numbers ... (1997)
WebCatalog can't find database (1997)
WCS Newbie question (1997)
test (2002)
are we ready to fix random sort? - Or did that already happen? (2000)
Is this possible, WebCat2.0 and checkboxes (1997)
Credit Card Number checking (1997)
PIXO support (1997)
Up and running ... at last !! (1997)
WebCatalog can't find database (1997)
WC2.0 Memory Requirements (1997)
[WebDNA] Search on a database (2012)
Trouble with Showif and Search (1998)
Zipcodes (1998)
RE: protect tag not working (1998)
RE: Missing contexts on NT (1997)