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:
Help with Shipping Costs (1997)
[random] only for 1-100??? (1997)
Re[2]: Formatting ModDate (2000)
[WebDNA] [raw] tag with [interpret] question (2010)
ACGI processing for .html (1997)
Why would prices no appear in cart (2000)
WebCatalog 4 Install Problems (2000)
4D Database (1997)
[WebDNA] fastcgi 7+ & [cart]? (2010)
The USArea® Network web site ... (1997)
Any WebCatters going to CeBit in Hanover, Germany? (2000)
Fixed: Problem getting shipping to calculate (2003)
OT (maybe) Setting up local (non internet) test computers (2000)
HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997)
WebCatalog f2 Installation (1997)
WCS Newbie question (1997)
Multiple Hideif peramiters (2001)
[ot] Bluetooth Phones That Allow SSH (2004)
HTTP Header / Meta Equiv (1999)
Database Fields (1997)