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 MarquardtDesigner/Resident WireheadToast Design800 Washington Avenue NorthMinneapolis MN 55401612.330.9863 v612.321.9424 fwww.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 MarquardtDesigner/Resident WireheadToast Design800 Washington Avenue NorthMinneapolis MN 55401612.330.9863 v612.321.9424 fwww.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:
Document Contains No Data! (1997)
unable to launch acgi in WebCat (1997)
displaying New products (using [date]) (1997)
Counting records (2000)
[WebDNA] how to clear the [username] and [password] values the browser has stored? (2008)
Email Format (Umlaut) (2004)
Notepad problems (1998)
Emailer setup (1997)
A sendmail warning (2005)
WebCat2.0 [format thousands .0f] no go (1997)
Snippet for finding unused Header Fields in the Orders.db (2003)
Protect (1997)
process SSI (1998)
catching WebDNA error messages (2003)
Separate SSL Server (1997)
Help! WebCat2 bug (1997)
[sendmail] possible modification needed... (2000)
Formating found categories (1997)
OT: Prevent Caching js Files (2003)
using cookies to prevent access (2000)